replace the specific date into the future date

Rahulvk
Rahulvk Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 2

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'

Answers

  • tgb417
    tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,601 Neuron

    @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.

Setup Info
    Tags
      Help me…