Guides & Tutorials

Dates and Times in the CSV file

The best format you can use for dates is ISO 8601: YYYY-MM-DD

We recommend this format because it is accepted worldwide. Find more information about subsets of this format by clicking here.

You can also use / as a separator between dates, with the order of the date elements dependent on what country you're located in. See more information in this article (eg. use format DD/MM/YYYY for those in Cyan colored countries, etc.) Using a subset of this format may cause issues, so best to keep all elements.

Keep in mind, 2-digit years that are less than 50 are parsed as 21st century years. For example, 04/16/17, previously parsed as April 16, 1917, will be April 16, 2017. To avoid any interoperability issues or ambiguous years, it is recommended to use the ISO 8601 format like "2017-04-16".

Why is Flow not interpreting this as a date?

Here are some common reasons this might happen:

  • If a column contains only names of months, such as January, they will be interpreted as text.
  • If you include only month and day, not in ISO format, such as 09/2020, there are too many ambiguous interpretations, so that format is not supported.

The full format for date-time is ISO 8601: YYYY-MM-DDTHH:mm:ss.sssZ, although be aware that time-related filtering is not yet available in the Editor.

Updated