Supported date formats
The following date formats are all supported. The example date is September 8, 2015.
We recognize date strings like "September 8, 2015" and various numeric dates:
| DD/MM/YYYY 08/09/2015 |
DD/MM/YY 08/09/15 |
D/MM/YYYY 8/09/2015 |
DD/M/YYYY 08/9/2015 |
DD/M/YY 08/9/15 |
| D/M/YYYY 8/9/2015 |
D/M/YY 8/9/15 |
MM/DD/YYYY 09/08/2015 |
MM/DD/YY 09/08/15 |
M/DD/YYYY 9/08/2015 |
| M/DD/YY 9/08/15 |
MM/D/YYYY 09/8/2015 |
MM/D/YY 09/8/15 |
M/D/YYYY 9/8/2015 |
M/D/YY 9/8/15 |
| MMM/DD/YYYY Sep/08/2015 |
MMM/DD/YY Sep/08/15 |
MMM/D/YYYY Sep/8/2015 |
MMM/D/YY Sep/8/15 |
YYYY/DD/MM 2015/08/09 |
| YY/DD/MM 15/08/09 |
YYYY/MM/DD 2015/09/08 |
YY/MM/DD 15/09/08 |
YYYY/M/DD 2015/9/08 |
YY/M/DD 15/9/08 |
The hyphen (2015-9-8) and the period (2015.9.8) can also be used as delimiters.
Datetimes must conform to the ISO 8601 standard or follow the format ddd MMM DD h:mm:ss ZZ YYYY. If the date is September 8, 2015, and the time is 11:34:18 EST:
| YYYY-MM-DDThh:mm:ssTZD — 2015-09-08T11:34:18-05:00 | ||||||||||||||||
| ||||||||||||||||
| ddd MMM DD hh:mm:ss ZZ YYYY — Wed Sep 8 11:34:18 -0500 2015 | ||||||||||||||||
|
You may also take any format in the first table and add a time to it. You can include seconds (DD/MM/YYYY hh:mm:ss) or exclude them (DD/MM/YYYY hh:mm). Keep in mind that hh ranges from 0 to 23, so 3:23 in the afternoon should be written as 15:23.