adding days to a date

[doylie]

I have several dates in the format 01/02/1999. All I need to know is how to add seven days to this date so it reads 08/02/1999.?

 

[Drevlin]

If you added 7 days to 01/02/1999 you'd get 01/09/1999 you'd do this by:

DateAdd("d", 7, "01/02/1999")

But since you seem to want to add 7 months:

DateAdd("m", 7, "01/02/1999")

Look up DateAdd in Help and it will explain the function in detail.

 

[simongallop]

Presume that you are using dd/mm/yyyy in which case use the DateAdd("d",... option.

 

[Drevlin]

I apologize. I forget that people use different Date formats depending on their country.
Typical American.

 

[doylie]

Cheers. The format was dd/mm/yyyy. English layout. No worries it worked a treat.