Announcing the winners & finalists of the Dataiku Frontrunner Awards 2021! Read their inspiring stories

how to truncate timestamp in now() in formula langugae

rsingamsetty
Level 3
how to truncate timestamp in now() in formula langugae

im using now() as a new column(refreshed_date) in Dataset to indicate dataset last refresh date,

but I want to keep only date in 'yyy-mm-dd ' format and truncate the timestamp, or if I have to keep timestamp I want it to be at UTC timezone level.

how can I achieve it ? Please help

 

1 Reply
Mattsco
Dataiker
Dataiker

Hi, 

You can use now().toString('yyyy-MM-dd') to keep only the date part. The results are always in local timezone in Formula. 

Mattsco
A banner prompting to get Dataiku DSS