create date column with string type

bichngoc
Level 1
create date column with string type

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

0 Kudos
1 Reply
CatalinaS
Dataiker

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

0 Kudos