calculate end date from start date using months

  • Thread starter dennisthemennis
  • Start date
D

dennisthemennis

I want to calculate and end date from a date entered and number of
months,into a form by a user. I am using dateadd, but it only calculates the
number of months not the actual date. Is there anyway around this ?
 
A

Allen Browne

What exactly are you after?

Perhaps you want the last day of the month 4 months from now:
DateSerial(Year(Date()), Month(Date()) + 4, 0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Top