For Date fields, specify the format of the date by using one of the following supported formats. Dates must match the format exactly and can't have any extra text.
note: The date formats listed here are the two-digit versions for date fields that use leading zeros; for example, 03/06/14 09:01:06 AM. If a date field doesn't have leading zeros, use the one-digit version of the format. For example, use the format M/d/yy h:m:s a for date values such as 3/6/14 9:1:26 AM. If you use a two-digit format for a field, rows containing values with one-digit date parts will fail.
The timestamp part of each date format is optional.
The Quarter date format isn’t supported.
| Format | Sample Value |
|---|---|
| yyyy-MM-dd'T'HH:mm:ss.SSS'Z' | 2014-04-29T16:53:34.000Z |
| yy-MM-dd'T'HH:mm:ss.SSS'Z' | 14-04-29T16:53:34.000Z |
| yyyy-MM-dd'T'HH:mm:ss'Z' | 2014-04-29T16:53:34Z |
| yy-MM-dd'T'HH:mm:ss'Z' | 14-04-29T16:53:34Z |
| yyyy-MM-dd HH:mm:ss | 2014-06-03 11:31:45 |
| yy-MM-dd HH:mm:ss | 14-06-03 11:31:45 |
| dd.MM.yyyy HH:mm:ss | 03.06.2014 11:31:45 |
| dd.MM.yy HH:mm:ss | 03.06.14 11:31:45 |
| dd/MM/yyyy HH:mm:ss | 03/06/2014 11:31:45 |
| dd/MM/yy HH:mm:ss | 03/06/14 11:31:45 |
| dd/MM/yyyy hh:mm:ss a | 03/06/2014 11:31:45 AM |
| dd/MM/yy hh:mm:ss a | 03/06/14 11:31:45 AM |
| dd-MM-yyyy HH:mm:ss | 03-06-2014 11:31:45 |
| dd-MM-yy HH:mm:ss | 03-06-14 11:31:45 |
| dd-MM-yyyy hh:mm:ss a | 03-06-2014 11:31:45 AM |
| dd-MM-yy hh:mm:ss a | 03-06-14 11:31:45 AM |
| MM/dd/yyyy hh:mm:ss a | 06/03/2014 11:31:45 AM |
| MM/dd/yy hh:mm:ss a | 06/03/14 11:31:45 AM |
| MM-dd-yyyy hh:mm:ss a | 06-03-2014 11:31:45 AM |
| MM-dd-yy hh:mm:ss a | 06-03-14 11:31:45 AM |
| HH:mm:ss dd/MM/yyyy | 11:31:45 03/06/2014 |
| HH:mm:ss dd/MM/yy | 11:31:45 03/06/14 |
These formats use the following symbols:
| Symbol | Meaning |
|---|---|
| yyyy or yy | Four-digit year (yyyy) or two-digit year (yy) |
| MM | Two-digit month (01–12) |
| M | One-digit month when month less than 10 (1–12) |
| dd | Two-digit day (01–31) |
| d | One-digit day when day less than 10 (1–31) |
| 'T' | A separator that indicates that time of day follows |
| HH | Two-digit hour (00–23) |
| H | One-digit hour when hour less than 10 (0–23) |
| mm | Two-digit minute (00–59) |
| m | One-digit minute when minute less than 10 (0–59) |
| ss | Two-digit second (00–59) |
| s | One-digit second when second less than 10 (0–59) |
| SSS | Optional three-digit milliseconds (000–999) |
| 'Z' | The reference UTC time zone |