Calculating Date over 1 year

  • Thread starter Thread starter chris wass
  • Start date Start date
C

chris wass

need help!
am doing project for college about tyre fitting company,
need to pull out all cars whose tyres were fitted over 1
year ago anyone know how?
cheers
 
Look at the Date Functions Date, DateSerial, and DateAdd. These can all be used
to calculate a date

DateAdd("YYYY",SomeOffSetNumber,Date())

That can be used to calculate a differe
 
Back
Top