I have an access database that has

[ronwmon]

I have an access database that has a from with a textbox (text2) that contains a date in the format yyyy-mm-dd.

I need to add one month to this date and include it on a report. I have tried the following:

=DateAdd("m",1,[Forms]![Prep]![Text2])

This dons not work. When I look st Report View the date is #Name?

Any assistance is appreciated.

Ron--

 

[Blorf]

Your form is named Prep, and it is open when you run the report? Also, is your text box text2 formatted as a short date or some other date, not general text?

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That DonÆt.

http://www.thelegacyreturns.com/

 

[ronwmon]

Thank you. I didn't have the form opened when I ran the report. I made a couple of changes based on your questions and now it works.

Ron--