When uploading a file in CSV format to VoC Store, it is important to use the correct DATE format for the column marked as [DATE]. Please see the list of all supported Date formats that can be used for [DATE] columns in CSV files in the table below:
|
Description |
Format |
Examples |
| American month and day | mm "/" dd |
"5/12", "10/27" |
| American month, day and year | mm "/" dd "/" y |
"12/22/78", "1/17/2006", "1/17/6" |
| Four-digit year, month and day with slashes | YY "/" mm "/" dd |
"2008/6/30", "1978/12/22" |
| Four-digit year and month (GNU) | YY "-" mm |
"2008-6", "2008-06", "1978-12" |
| Year, month and day with dashes | y "-" mm "-" dd |
"2008-6-30", "78-12-22", "8-6-21" |
| Day, month and four-digit year, with dots, tabs or dashes | dd [.\t-] mm [.-] YY |
"30-6-2008", "22.12.1978" |
| Day, textual month and year | dd ([ \t.-])* m ([
\t.-])* y |
"30-June 2008", "22DEC78", "14 III 1879" |
| Textual month and four-digit year (Day reset to 1) | m ([ \t.-])* YY |
"June 2008", "DEC1978", "March 1879" |
| Four-digit year and textual month (Day reset to 1) | YY ([ \t.-])* m |
"2008 June", "1978-XII", "1879.MARCH" |
| Day and textual month | d ([ .\t-])* m |
"1 July", "17 Apr", "9.May" |
| Month abbreviation, day and year | M "-" DD "-" y |
"May-09-78", "Apr-17-1790" |
| Year, month abbreviation and day | y "-" M "-" DD |
"78-Dec-22", "1814-MAY-17" |
| Year (and just the year) | YY |
"1978", "2008" |
| Textual month (and just the month) | m |
"March", "jun", "DEC" |
| Eight digit year, month and day | YY MM DD |
"15810726", "19780417", "18140517" |
| Four-digit year, month and day with slashes | YY "/" MM "/" DD |
"2008/06/30", "1978/12/22" |
| Two-digit year, month and day with dashes | yy "-" MM "-" DD |
"08-06-30", "78-12-22" |
| Four-digit year with an optional sign, month and day | [+-]? YY "-" MM "-" DD |
"-0002-07-26", "+1978-04-17", "1814-05-17" |
Comments
0 comments
Article is closed for comments.