Help With Date

[David Tunstall]

Please help,

I have a form that uses the date add function to a
specified start date.

I.E Start Date = 26/01/2003
Months = 12
New Date = 26/01/2004

How can i make the new date show the last day of the
month that it calculates - i.e 31/01/2004

Thanks
David

 

[Rick Brandt]

Please help,

I have a form that uses the date add function to a
specified start date.

I.E Start Date = 26/01/2003
Months = 12
New Date = 26/01/2004

How can i make the new date show the last day of the
month that it calculates - i.e 31/01/2004

NewDate = DateSerial(Year(OldDate)+1, Month(OldDate) + 1, 0)