VBA and Date Fields

[jsterling0231]

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:

 

[bob fitz]

Try the DateAdd() function. See Access help files for the syntax etc. Post back if you have any problems.

 

[rzw0wr]

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