replace the specific date into the future date

Rahulvk
Level 1
replace the specific date into the future date

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' 

0 Kudos
1 Reply
tgb417

@Rahulvk 

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.  

--Tom
0 Kudos

Labels

?
Labels (2)

Setup info

?
A banner prompting to get Dataiku