|
Date Format |
Description |
|---|---|
|
MM-DD-YY |
Represents the date with two digits for the month, followed by two digits for the day and two digits for the year; all separated with dashes (-). |
|
MM-DD-YYYY |
Represents the date starting with two digits for the month, followed by two digits for the day and four digits for the year; all separated with dashes (-). |
|
YY-MM-DD |
Represents the date starting with two digits for the year, followed by two digits for the month and two digits for the day; all separated with dashes (-). |
|
YYYY-MM-DD |
Represents the date starting with four digits for the year, followed by two digits for the month and two digits for the day; all separated with dashes (-). |
|
MM-DD |
Represents the date starting with two digits for the month, followed by two digits for the day; separated with a dash (-). |
|
Month DD, YYYY |
Represents the date starting with three letter abbreviation for the month name, followed by two digits for the day and four digits for the year. |
|
Locale specific |
Enters the date using the format specified in the Windows Regional Options dialog box. |
|
Day of month only |
Enters only the day of the month, numerically, from the given date values. |
|
Month only (1-12) |
Enters only the month, numerically, from the given date values. |
|
Short month name |
Enters an abbreviation of the month name from the given date values. Example: If the date is 11-11-2002 and the date is formatted to display the Short month name, Nov will display. |
|
Long month name |
Enters the month name from the given date values. Example: If the date is 11-11-2002 and the date is formatted to display the Long month name, November will display. |
|
Two digit year only |
Enters the last two digits of the year from given date values. |
|
Four digit year only |
Enters the full four digits of the year from given date values. |
|
Short day of week |
Enters an abbreviation of the name of the day of the week given date values fall on. Example: If the date is 11-11-2002 and the date is formatted to display the Short day of week, Mon will display. |
|
Long day of week |
Enters an abbreviation of the name of the day of the week given date values fall on. Example: If the date is 11-11-2002 and the date is formatted to display the Long day of week, Monday will display. |