This documentation is archived and is not being maintained.

Format Strings

Exchange Server 2003

Format Strings

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release. 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
Show: