Add future date with a button

[Chad]

Hi,

I have a "last calibration" field on a form that is updated through
the calendar control. Below that, I have a "Next Calibration Due"
field that I would like to populate 1 year forward from the last
calibration field. I used the expression builder "=DateSerial(Year
([StartDate]),Month([StartDate])+12,Day([StartDate]))" which works,
however that field remains blank in the report.

I thought perhaps just adding a button beside the "next calibration"
field to calculate would be easiest.

Thanks in advance,

Chad

 

[Mr. B]

Take a look at the DateAdd function. You can even use this function in the
Control Source of your text box where the calculated date is to be entered.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[Chad]

Take a look at the DateAdd function.  You can even use this function inthe
Control Source of your text box where the calculated date is to be entered.

-----
HTH
Mr. Bhttp://www.askdoctoraccess.com/
Doctor Access Downloads Page:http://www.askdoctoraccess.com/DownloadPage.htm

Hi,

I have a "last calibration" field on a form that is updated through
the calendar control.  Below that, I have a "Next Calibration Due"
field that I would like to populate 1 year forward from the last
calibration field.  I used the expression builder "=DateSerial(Year
([StartDate]),Month([StartDate])+12,Day([StartDate]))" which works,
however that field remains blank in the report.

I thought perhaps just adding a button beside the "next calibration"
field to calculate would be easiest.

Thanks in advance,

Chad
.

Thanks so much! This works much better. I created a query with a
"period (1 default, hidden) value with the DateAdd function and it
works perfectly.

Thank you!

Chad