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 being 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 Scatter, Table, Radar, Sankey 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