Survey banner
The Dataiku Community is moving to a new home! New posts are now disabled and the community will shortly be in temporary read only mode: LEARN MORE

US date format

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

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,

0 Kudos