US date format

PARA
Level 1
US date format

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

0 Kudos
1 Reply
arnaudde
Dataiker

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

Screen Shot 2021-01-18 at 16.26.34.png

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

Screen Shot 2021-01-18 at 16.27.08.png

โ€ƒ

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

Screen Shot 2021-01-18 at 16.27.26.png

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

 

I hope it helps,
Arnaud

0 Kudos