Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
In the date column i have dates in the format '1900-01-01T00:00:00.000Z' i need to replace this date to tomorrow date dynamically. How can i do that using formula ?
i.e from 1900-01-01T00:00:00.000Z to '18-08-2023'
Welcome to the dataiku community. We are so glad to have you join us.
Iโm not at my Dataiku Instance. So I can not write this out in detail. However, I can provide some hints that may get you going in a useful direction.
Take a look at transforming your dataset with a visual prepare recipient.
https://doc.dataiku.com/dss/latest/preparation/index.html
There are lots of things that you can do with a visual prepare recipient to transform your data.
One of the kinds of visual steps you can do is a formula step. Here is a video about formula steps
https://academy.dataiku.com/visual-recipes-102/671235
In the formula language there are functions for logic, comparisons, and date functions. Here is a link to the formula language.
https://doc.dataiku.com/dss/latest/formula/index.html
You should be able to write a formula that says if the date is your target data then make the column the date of now plus 1 day. You should also be able to truncate the resulting date time to the beginning of the day if that is what you need.
Please note unlike MS Excel the Dataiku formula language is case sensitive. So, for example, if you want to do an โifโ function. You need to enter it as in the documentation as all lower case โifโ. Entering that function as any of these โIFโ or โIfโ or โiFโ will cause an error.
Good luck, please let the community know how you are getting on with your puzzle.