VBA and Date Fields

jsterling0231

New member
Local time
Today, 00:53
Joined
May 29, 2013
Messages
5
Hi All,
I am new to programming in Access and need help with some code using a date field in a table. I want Access to calculate a date that is entered by the user, add 22 months to this date and return a new date. That is calculate 22 month out from the original date. Can anyone help me with this problem? Any help is greatly appreciated.

Thank you,
Julie :banghead:
 
Try the DateAdd() function. See Access help files for the syntax etc. Post back if you have any problems.
 
Julie, Are you doing this in a table? A calculated field.

If so, you may want to rethink you approach.

Look into the DateAdd Function.

Dale
 

Users who are viewing this thread

Back
Top Bottom