Date
Date Mask strings can use the following characters:
| Code |
Representation |
| d |
The number of the day: 1 – 31 |
| dd |
The number of the day, 2-digits: 01-31 |
| ddd |
Abbreviated name of the day: Sat - Sun |
| dddd |
The full name of the day: Saturday - Sunday |
| M |
The number of the month: 1-12 |
| MM |
The number of the month, 2-digits: 01-12 |
| MMM |
Abbreviated name of the month: Dec – Jan |
| MMMM |
The full name of the month: December – January |
| yy |
The year, 2-digits: 00-99 |
| yyyy |
The year, 4-digits: 0000-9999 |
| g |
Period/era string, usually A.D. |
Examples
| Mask |
Explanation |
"ddd',' MMM dd yyyy" |
Format the date with a 4 digit year date |
"ddd',' MMM dd yy" |
Format the date with a 2 digit year date |
Notes
- The use of quotes around the comma is optional.
- The double quotes in the example masks are needed when using the FormatDate function and need to be omitted when used via the field properties dialog.