create date column with string type

Options
bichngoc
bichngoc Registered Posts: 4 ✭✭✭
in Using Dataiku

Hi,

I have to create a column that shows only date of today with string form: "2022-19-07".

However, I created a column from formula : now() but it returns datetime column like "2022-07-19T09:51:40.937Z".

How can I create a date column with string form: "2022-19-07" ?

Thanks,

Mac

· Share on FacebookShare on Twitter

Answers

  • Catalina
    Catalina Dataiker, Dataiku DSS Core Designer, Registered Posts: 135 Dataiker
    Options

    Hi @bichngoc

    If you want to create a column that shows the date of today as "2022-19-07" you can add a step in the prepare recipe that formats the date as "y/dd/MM".

    Screenshot 2022-07-19 at 12.40.22.png

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…