Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

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