Using Dataiku
Sort by:
1 - 6 of
6
- Hi Team. Is there a dataprocessor or function to add months to a given date. Something like for ex : dateadd function in SQL. ex 1: for todays date(24-Aug-2020), i would like to add 4 months then it w…
Solution by tgb417It is not intuitive how to do this, if you know SQL.
However, you can use a formula step in a visual prepare recipe to make these changes.
You are looking for the inc (increment function) in the Formula.
for example
inc(LastUpdated, 4, "month")
Will add 4 months to a date in LastUpdated column if that column has been parsed to a DSS standard format with the date parse command.
Hope this works for you.
You can find the documentation on the date formula functions here
https://doc.dataiku.com/dss/latest/advanced/formula.html#date-functions
1 - 6 of
61