thorpey83
asked on
Need to add years to a date in an Access 2007 query
I am try to create a query the takes the date from 'Date Job completed' then adds 11 years and put a date in a field called 'Date for Destruction.' Does anyone know what I need to do to get this to work. I am guessing it is done in the field of a query.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Select * ,Dateadd("yyyy", 11, [Date Job completed]) as "Date for Destruction" From MyTable
Gary