CALCULATING FUTURE DATE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does Access have a function similar to SQL's ADD_MONTHS? I want to set a date
field based on an date entry in another field times the number of years in a
third field. Thanks
 
Yes, use the DATEADD function. The help files will give you all the
parameters.
 
check help on function called DateAdd, you can add to a specific date houres,
days, month, etc

DateAdd("yyyy",[AmountOfYearsFieldName],[DateFieldName])

Add years to the date field
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a calculated date in a field on input form 4
Writing a General Date from separate date and time fields 3
Using Max or DMax in DLookUp criteria? 1
Autopopulate a Weekdate from a Recieved date 5
Date and Time 3
Age from Date Function 5
Time Calculation For Particular Person On Particular Date 6
Access Validation rule in MS access 2010 1

Back
Top