Survey banner
Share your feedback on the Dataiku documentation with this 5 min survey. Thanks!

# Compute diff between dates and number of days

Solved!
Level 3
###### 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 ?

1 Solution

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

4 Replies

Hi,

You can pass negative values to the inc() function if you need to decrement dates, like this:

Hope this helps!

Best,

Harizo

Level 3
Author

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=?

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

Level 3
Author

Thanks a lot @har

. it worked.