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
 
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
 
Back
Top