The table below provides examples of date/time formats to help you select or enter the appropriate format.
| Date/Time Format | Example 1 | Example 2 |
April 1st, 2018 3:20:15 pm PDT | October 21st, 2018 11:53:12 am PDT | |
| YYYY-MM-DDTHH:mm:ssZ | 2018-04-01T15:20:15-07:00 | 2018-10-21T11:53:12-07:00 |
| YYYY-MM-DDTHH:mm:ss | 2018-04-01T15:20:15 | 2018-10-21T11:53:12 |
| YYYY-MM-DDTHH:mm:ss[Z] | 2018-04-01T15:20:15Z | 2018-10-21T11:53:12Z |
| YYYY-MM-DDTHH:mm:ss.SSSZZ | 2018-04-01T15:20:15.000-0700 | 2018-10-21T11:53:12.000-0700 |
| YYYY-MM-DDTHH:mm:ss.SSSSZ | 2018-04-01T15:20:15.000-07:00 | 2018-10-21T11:53:12.000-07:00 |
| YYYY-MM-DD HH:mm:ss | 2018-04-01 15:20:15 | 2018-10-21 11:53:12 |
| X | 1522621215 | 1540147992 |
| M/D/YYYY | 4/1/2018 | 10/21/2018 |
| YYMMDD | 180401 | 181021 |
| MMDDYY | 040118 | 102118 |
| DDMMYY | 010418 | 211018 |
| DDMMYYYY | 01042018 | 21102018 |
| DDMMYYYY hh:mm | 01042018 03:20 | 21102018 11:53 |
| DDMMYYYY hh:mm:ss | 01042018 03:20:15 | 21102018 11:53:12 |
| MM/DD/YYYY hh:mm:ss SS | 04/01/2018 03:20:15 00 | 10/21/2018 11:53:12 00 |
| MM/DD/YYYY hh:mm A | 04/01/2018 03:20 PM | 10/21/2018 11:53 AM |
| MM/DD/YYYY hh:mm:ss A | 04/01/2018 03:20:15 PM | 10/21/2018 11:53:12 AM |
| DD/MM/YYYY | 01/04/2018 | 21/10/2018 |
| DD/MM/YYYY hh:mm | 01/04/2018 03:20 | 21/10/2018 11:53 |
| DD/MM/YYYY hh:mm:ss SS | 01/04/2018 03:20:15 00 | 21/10/2018 11:53:12 00 |
| DD-MMM-YYYY hh:mm A | 01-Apr-2018 03:20 PM | 21-Oct-2018 11:53 AM |
| DD/MM/YYYY hh:mm:ss A | 01/04/2018 03:20:15 PM | 21/10/2018 11:53:12 AM |
| YYYY/MM/DD | 2018/04/01 | 2018/10/21 |
| YYYY/MM/DD hh:mm | 2018/04/01 03:20 | 2018/10/21 11:53 |
| YYYY/MM/DD hh:mm:ss | 2018/04/01 03:20:15 | 2018/10/21 11:53:12 |
| YYYY/MM/DD hh:mm:ss SS | 2018/04/01 03:20:15 00 | 2018/10/21 11:53:12 00 |
| YYYY/MM/DD hh:mm:ss A | 2018/04/01 03:20:15 PM | 2018/10/21 11:53:12 AM |
| YYYY/MM/DD hh:mm A | 2018/04/01 03:20 PM | 2018/10/21 11:53 AM |
| DD-MMM-YYYY | 01-Apr-2018 | 21-Oct-2018 |
| MMM DD YYYY hh:mm A | Apr 01 2018 03:20 PM | Oct 21 2018 11:53 AM |
| MMMM DD YYYY hh:mm:ss A | April 01 2018 03:20:15 PM | October 21 2018 11:53:12 AM |
| DD.MM.YYYY | 01.04.2018 | 21.10.2018 |
| MM.DD.YYYY | 04.01.2018 | 10.21.2018 |
| hh:mm:ss.SSS Z | 03:20:15.000 -07:00 | 11:53:12.000 -07:00 |
| hh:mm:ss Z | 03:20:15 -07:00 | 11:53:12 -07:00 |
| hh:mm:ss A Z | 03:20:15 PM -07:00 | 11:53:12 AM -07:00 |
| hh:mm:ss A | 03:20:15 PM | 11:53:12 AM |
| hh:mm:ssA | 03:20:15PM | 11:53:12AM |
| hh:mm:ss.SSA | 03:20:15.00PM | 11:53:12.00AM |
| hh:mm:ss.SS | 03:20:15.00 | 11:53:12.00 |
| hh:mm:ss | 03:20:15 | 11:53:12 |