how do I subract a given date from the current date in Access quer

  • Thread starter Thread starter Guest
  • Start date Start date
You should use the DateDiff function

Select DateDiff("d",[DateFieldName],Date()) As DiffInDays From TableName

Check the datediff with the options you have
different in days, month, year etc
 
Back
Top