Supported date/time formats by the data typing feature
Our auto-set column bindings make the process of adding data quick and easy. However, not all date/time formats are recognized by the algorithm – see a list of all supported formats below, or read how to change the output format in this help doc.
WARNING: Please note that at the moment, data typing is supported in the Line, Bar, Pie, Scatter, Table, Radar, Sankey, Line chart race, Projection map, Slope, Bar chart race, Cards, Hierarchy and Timeline templates only.
WARNING: At the moment, Flourish only recognizes written months in English. If you use date formats like 21 février 1967 or 21 febbraio 1967, your data will be recognized as text and the date/time columns won't work.
| DAY FIRST |
||
| 27/04/1972 | 27/04/72 | |
| 27-04-1972 | 27-04-72 | |
| 27 Apr 1972 | 27 April 1972 | |
| 27 Apr 72 | 27 April 72 | |
| 27-Apr-1972 | 27-April-1972 | |
| 27-Apr-72 | 27-April-72 | |
| 27 Apr | 27 April | |
| 27-04 | 27/04 | |
| MONTH FIRST |
|
|
| 04/27/1972 | 04/27/72 | |
| 04-27-1972 | 04-27-72 | |
| 04/1972 | 04/72 | |
| Apr 1972 | April 1972 | |
| Apr 72 | April 72 | |
| Apr 27 | April 27 | |
| 04-27 | 04/27 | |
| Apr | April | |
| YEAR FIRST |
||
| 1972-04-27T19:45:05.000Z | 1972/04/27 |
|
| 1972-04-27 | 1972 | |
| 1972 Q2 | ||
| OTHER FORMATS |
||
| 7:45:05 PM | 07:45 PM | |
| 19:45 | 19:45:05 | |
| 7PM | Q2 1972 | |
| |