Changing a date

[Matthew Mandalek]

Is there any easy way to update a DATE field? I have the following values:

NextDate - next date to run
Cycle - the run cycle (Day, Week, Month, Year)

NextDate needs to be updated by Cycle. Do I need to write the code, or is
there any simply way to do this? Also, if I have to write code, how do I
know when it is leap year?

Thanks

Matt

 

[Douglas J. Steele]

Is the DateAdd function sufficient? It knows about leap years.

 

[Matthew Mandalek]

I knew there was any easy way..

Thaks

Is the DateAdd function sufficient? It knows about leap years.

 

[PC Datasheet]

Look at the DateAdd function in the Help file. It will automatically take care
of leap years for you.