Help With Date

  • Thread starter Thread starter David Tunstall
  • Start date Start date
D

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
 
David Tunstall said:
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
Click to expand...

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