Add One Day to a Date

[NewfieGolfer]

Hi All,

I want to add one day to a date. So if I have date1 = "5/20/2002", I would like a function that adds one day and gets date1 = 5/21/2002. So it's basically date1 = date1 + 1 (but i know this doesn't work - type mismatch).

Any help appreciated,
NG

 

[GGleason]

Try this:

[tt]date1 = #5/20/2002#
date1 = date1 + 1
[/tt]
hth,
GGleason