Format Strings
Exchange Server 2003
The following table shows formats that can be applied to fields using attributes, and to views using the format tag.
| Format String | Applies to Data Types | Example |
|---|---|---|
| "" | String, MVString | Text |
| "" | Integer, Real | 1,234.567 1,234.567 |
| "#,#" | Integer, Real | 1,2345 -1,2345 |
| "#,#.0" | Integer, Real | 1,234,6 1,234,6 |
| "#,#.00" | Integer, Real | 1,234,57 1,234.57 |
| "" | Date/Time | 9/24/1999 12:18:44 PM |
| "M/d/yyyy|| h:mm:ss tt" | Date/Time | 9/24/1999 12:18:44 PM |
| "MMMM d, yyyy" | Date/Time | September 24, 1999 |
| "d-MMM-yy" | Date/Time | 24-Sep-99 |
| "M/d/yyyy" | Date/Time | 9/24/1999 |
| "MMMM yy" | Date/Time | September 99 |
| "M/yyyy" | Date/Time | 9/1999 |
| "h:mm tt" | Date/Time | 12:18 PM |
| "h:mm" | Date/Time | 12:18 |
