US date format

PARA

How to check if the date values in a particular column are in US date format using prepare recipe

arnaudde

Hello Para,
If the meaning of your column (displayed in blue under the name of your column) is Date(unparsed)

You can click on the column name and then Parse date...

 

You will have all the inferred types available and the percentage of rows that match each format.

This will tell you if the dates in a column are likely to be of US date format.

I hope it helps,
Arnaud