how to truncate timestamp in now() in formula langugae
![rsingamsetty](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar4.png)
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
-
Hi,
You can use now().toString('yyyy-MM-dd') to keep only the date part. The results are always in local timezone in Formula.