Valid Date Format Keywords
The following table shows the keywords for valid formats, with a description and example of each.
| Keyword | Description | Example(s) |
|---|---|---|
MM |
2-digit month | 01, 02, 03, ..., 12 |
MMDD |
2-digit month and 2-digit day | March 31 is 0331 |
MMDDYY |
2-digit month, 2-digit day, and 2-digit year | March 31, 1970 is 033170 |
MMDDYYYY |
2-digit month, 2-digit day, and 4-digit year | March 31, 1970 is 03311970 |
DELIM_M_D |
Any delimited month followed by day | March 31, 3/31, or 03-31 |
DELIM_M_D_Y |
Any delimited month, day, and year | March 31, 1970 or 3/31/70 |
DELIM_M_D_YYYY |
Any delimited month, day, and 4-digit year | March 31, 1970 or 3/31/1970 |
DELIM_Y_M |
Any delimited year followed by month | March, 70; 3-70; or 3/1970 |
DELIM_Y_M_D |
Any delimited year, month, and day | 1970 Mar 31 or 70/3/31 |
YYMMM |
2-digit year and 3-letter month | 70MAR |
YYMMMDD |
2-digit year, 3-letter month, and 2-digit day | 70MAR31 |
YY |
2-digit year | 70 |
YYMM |
2-digit year and 2-digit month | 7003 |
YYMMDD |
2-digit year, 2-digit month, and 2-digit day | 700331 |
YYYYMMM |
4-digit year and 3-letter month | 1970MAR |
YYYYMMMDD |
4-digit year, 3-letter month, and 2-digit day | 1970MAR31 |
YYYY |
4-digit year | 1970 |
YYYYMM |
4-digit year and 2-digit month | 197003 |
YYYYMMDD |
4-digit year, 2-digit month, and 2-digit day | 19700331 |
DELIM_M_Y |
Any delimited month followed by year | 3-70, 3/70, Mar 70, March 1970 |
DELIM_D_M |
Any delimited day followed by month | 31-3, 31/3, 31 March |
DELIM_D_M_Y |
Any delimited day, month, and year | 31-MAR-70, 31/3/1970, 31 03 70 |
DD |
2-digit day | 31 |
DDMMM |
2-digit day and 3-letter month | 31MAR |
DDMMMYY |
2-digit day, 3-letter month, and 2-digit year | 31MAR70 |
DDMMMYYYY |
2-digit day, 3-letter month, and 4-digit year | 31MAR1970 |
DDMM |
2-digit day and 2-digit month | 3103 |
DDMMYY |
2-digit day, 2-digit month, and 2-digit year | 310370 |
DDMMYYYY |
2-digit day, 2-digit month, and 4-digit year | 31031970 |
MMYY |
2-digit month and 2-digit year | 0370 |
MMYYYY |
2-digit month and 4-digit year | 031970 |
MMM |
3-letter month | MAR |
MMMDD |
3-letter month and 2-digit day | MAR31 |
MMMDDYY |
3-letter month, 2-digit day, and 2-digit year | MAR3170 |
MMMDDYYYY |
3-letter month, 2-digit day, and 4-digit year | MAR311970 |
MMMYY |
3-letter month and 2-digit year | MAR70 |
MMMYYYY |
3-letter month and 4-digit year | MAR1970 |
MONTH |
Month of the year | January, February, March, and so on or Jan, Feb, Mar, and so on |
WEEKDAY |
Day of the week | Sunday, Monday, Tuesday, and so on (Sunday = 0) |
WKD |
Abbreviated day of the week | Sun, Mon, Tues, and so on (Sun = 0) |