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

date calculation 5
Date calculation on 2 fields 5
projecting a finish date for a project? 5
Difference of 2 columns 4
Queries? 9
Subracting double is a problem in c# 1
Subracting days from a date (in workdays) 1
Subtracting Dates to get total time work time excluding weekends 2

Back
Top