Compute diff between dates and number of days
Hi , Is there a way to have date column as input and number if days stored in Integer format.
i want to subtract them and have my output stored in a date column. The inc() function will not work because i have the column name and can be used only for incrementing dates by a number.
Suppose i want to decrement a date by a particular column having bigint , then could you pls guide how to do achieve that ?
Best Answer
-
Hi,
If all your column's values are positive and you want to decrement from it, you can just multiply it by -1 to achieve the desired output:
inc(date, -1*delta_days, "days")
Best,
Harizo
Answers
-
Hi,
You can pass negative values to the inc() function if you need to decrement dates, like this:
Hope this helps!
Best,
Harizo
-
Ankur5289 Partner, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Registered Posts: 27 PartnerOptions
Thanks @HarizoR
for the response. I am having fixed positive integers, is it possible to decrement dates by positive integers. or do you have any ways to transform a postive number to negative number=?