Date & Time Formatting Commands
The following is a table that represents the different formatting options that can be set for date and time fields.
| Code | Value |
|---|---|
| <empty> | Use the system default format |
| date | Display only the date using the current locale settings |
| time | Display only the time using the current locale settings |
| yy | Last two digits of year |
| yyyy | Full year |
| M | One or two digit month |
| MM | Two digit month (single digits are preceded by 0) |
| MMM | Three character month abbreviation |
| MMMM | Full month name |
| d | One or two digit day |
| dd | Two digit day (single digits are preceded by 0) |
| ddd | Three character weekday abbreviation |
| dddd | Full weekday name |
| h | One or two digit hour in 12-hour format |
| hh | Two digit hour in 12-hour format |
| H | One or two digit hour in 24-hour format |
| HH | Two digit hour in 24-hour format |
| m | One or two digit minute |
| mm | Two digit minute (single digits are preceded by 0) |
| s | One or two digit second |
| ss | Two digit second (single digits are preceded by 0) |
| t | A or P |
| tt | AM or PM |
Note: The y, d, s, and t codes are case-insensitive.
For example, if you want the date format to be 09/02/05, you would enter MM/DD/YY in the Date Format field. For a date format of September 2, 2005 - 1:26:32, you would enter MMMM D, YYYY - h:mm:ss.
Last modified 2010-06-09 08:52 AM
