Automatic Date Calculation

  • Thread starter Thread starter Neil Warwick
  • Start date Start date
N

Neil Warwick

Does anyone know how I can automatically calculate a date
based on a start date and interval time?
e.g. I have a form with a control that records the date
for an event say 1st May 2004, I have another control
that specifies how many months into the future that event
should occur again, what I would like is for a 3rd
control to be automatically calculated based on the two
previous controls. SO if the user has an interval of 6
(months) then the 3rd control (Due Date) should be
automatically calculated as 1st November 2004.
Monthly intervals would be anywhere from 1 to 36.

Any help or info anyone can give to me would be
appreciated as I@m really struggling with this one.

Thanks

Neil
 
Does anyone know how I can automatically calculate a date
based on a start date and interval time?
e.g. I have a form with a control that records the date
for an event say 1st May 2004, I have another control
that specifies how many months into the future that event
should occur again, what I would like is for a 3rd
control to be automatically calculated based on the two
previous controls. SO if the user has an interval of 6
(months) then the 3rd control (Due Date) should be
automatically calculated as 1st November 2004.
Monthly intervals would be anywhere from 1 to 36.

Any help or info anyone can give to me would be
appreciated as I@m really struggling with this one.

Thanks

Neil
Click to expand...

Set that DueDate control's control source to:
=DateAdd("m",[IntervalField],[StartDate])

Look up the DateAdd function in VBA help.
 
Back
Top