Is there a function to add days to a date

[#1]

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!

[hector · Accepted solution]

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