Compute diff between dates and number of days

Ankur5289

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 ?

HarizoR

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

HarizoR

Hi,

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

Hope this helps!

Best,

Harizo

Ankur5289

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

Ankur5289

Thanks a lot @har

. it worked.