Is there a function to add days to a date

Mon, 01 Mar 2010 17:38:59 GMT

As part of my load script, I have a date field and an integer field. I would like to add integer (#/days) to the date. Is there any easy way to do this, other than stripping the date down to year, month, day, performing the add & putting it back together again?

Thanks in advance for your help!

Is there a function to add days to a date

hector — Mon, 01 Mar 2010 18:02:46 GMT

Hi, to add days to a date field, just sum (i mean '+' in the script), some examples:

May 1st 2010 (internally with value 40299) + 1 (in this case 1 day) returns May 2nd 2010 (internally with value 40300)

Rgds

topic Is there a function to add days to a date in QlikView

Is there a function to add days to a date

Is there a function to add days to a date