The best format you can use for dates is ISO 8601:
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 "
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.