Sample Mask Strings
Text Mask Type or None
| Mask | Raw Data | Formatted Data |
|---|---|---|
| ###-##-#### | "012345678" | 012-34-5678 |
| (###) ###-#### | "2125551212" | (212) 555-1212 |
Date Mask Type
| Mask | Raw Data | Formatted Data |
|---|---|---|
| Ddd - Mmm d, yyyy | 9/22/1998 | Tue - Sep 22, 1998 |
| m/d/yy | 9/22/1998 | 9/22/98 |
| Mmmm d | 9/22/1998 | September 9 |
Special Note
- Raw Data shows dates in U.S. format. Depending on your Windows Regional Settings, raw data may be displayed in a different format.
DateTime Mask Type
| Mask | Raw Data | Formatted Data |
|---|---|---|
| mm/dd/yyyy hh:mm:ss.fff | 12/8/1969 2:06:45 AM | 12/08/1969 02:06:45.000 |
| mm/dd/yyyy hh:mm:ss.f | 12/8/1969 2:06:45 AM | 12/08/1969 02:06:45.0 |
Special Note
- Raw Data shows dates and times in U.S. format. Depending on your Windows Regional Settings, raw data may be displayed in a different format.
Numeric and Currency Mask Type
| Mask | Raw Data | Formatted Data |
|---|---|---|
| $#,##0;($#,##0) | 1001.536 | $1,002 |
| $#,##0;($#,##0) | -1001.536 | ($1,002) |
| 0.00 | -0.2 | -0.20 |
| 00000 | 123 | 00123 |
| -> *<- | 104 | -> 104<- |
| 0. | 30.2500 | 30.25 |
| +0.00;-0.00 | 12 | +12.00 |
Special Note
- Be careful with "$", because this simply adds the literal dollar symbol to the mask. If you want your mask to adjust the currency symbol according to the Windows locale currency setting, then do not use literal symbols like "$" in your mask. The
Default_Currency_Symbol()function can be used to build a mask string that will substitute the Windows locale currency symbol into your mask at run time. See Default_Currency_Symbol for more information.