create date column with string type

bichngoc

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

Catalina

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".