how to truncate timestamp in now() in formula langugae

rsingamsetty
rsingamsetty Dataiku DSS Core Designer, Dataiku DSS & SQL, Registered Posts: 18 ✭✭✭✭✭

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

Answers

Setup Info
    Tags
      Help me…