US date format

PARA
PARA Registered Posts: 7 ✭✭✭

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

Answers

  • arnaudde
    arnaudde Dataiker Posts: 52 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

Setup Info
    Tags
      Help me…