how do I subract a given date from the current date in Access queries?
O Ofer Jan 16, 2006 #2 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 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
