Date function

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Have a form that the user will enter a date. I then have
two hidden text boxes that I want to be populated with
the next consecutive months. Example:

User enters:
07/01/04

I want the two text boxes to then be populated with:
08/01/04
and
09/01/04

Any ideas?

Thanks,
 
steve said:
Have a form that the user will enter a date. I then have
two hidden text boxes that I want to be populated with
the next consecutive months. Example:

User enters:
07/01/04

I want the two text boxes to then be populated with:
08/01/04
and
09/01/04

Any ideas?

Thanks,
Click to expand...

Controlsources

=DateAdd("m", 1, [UserEnteredDate])

=DateAdd("m", 2, [UserEnteredDate])

But why do you need to put this calculated data into hidden text boxes?
Can't you just use the calculation itself anywhere you need it?
 
Back
Top