The various BYOD templates accept multiple date formats for date fields (i.e. start_date, end_date, date). In order to ensure that these dates are parsed correctly, you will be asked to specify a date order upon upload of BYOD file. The three date order options are:
- Year-Month-Day
- Day-Month-Year
- Month-Day-Year
Your most recent date order selection will be saved on a per-channel basis for ease of use, but the date order can always be adjusted when a new file is imported.
Dates can be input with either slashes or dashes.
Years can be input as either 2-digit or 4-digit years. 2-digit years are assumed to be in the 2000s (e.g. 00 is assumed to be 2000).
Please see below for the complete list of accepted date formats.
Year-Month-Day
| Date format | Example (January 2, 2000) |
| YYYY-MM-DD | 2000-01-02 |
| YYYY/MM/DD | 2000/01/02 |
| YY-MM-DD | 00-01-02 |
| YY/MM/DD | 00/01/02 |
| YYYY-M-D | 2000-1-2 |
| YYYY/M/D | 2000/1/2 |
| YY-M-D | 00-1-2 |
| YY/M/D | 00/1/2 |
Month-Day-Year
| Date format | Example (January 2, 2000) |
| MM-DD-YYYY | 01-02-2000 |
| MM/DD/YYYY | 01/02/2000 |
| MM-DD-YY | 01-02-00 |
| MM/DD/YY | 01/02/00 |
| M-D-YYYY | 1-2-2000 |
| M/D/YYYY | 1/2/2000 |
| M-D-YY | 1-2-00 |
| M/D/YY | 1/2/00 |
Day-Month-Year
| Date format | Example (January 2, 2000) |
| DD-MM-YYYY | 02-01-2000 |
| DD/MM/YYYY | 02/01/2000 |
| DD-MM-YY | 02-01-00 |
| DD/MM/YY | 02/01/00 |
| D-M-YYYY | 2-1-2000 |
| D/M/YYYY | 2/1/2000 |
| D-M-YY | 2-1-00 |
| D/M/YY | 2/1/00 |
Comments
0 comments
Article is closed for comments.