Full Version: ALL records for a 2 monthers prior than todays date
UtterAccess Forums > Microsoft® Access > Access Date + Time
nikb3522
How can I write a query where I find all records where the date is at least 2 months old?
truittb
WHERE YourDateField <= DateAdd("m",-2,Date())
freakazeud
Hi,
in the criteria of the date field in your query use:
lt;=DateAdd("m",-2,Date())
This would return all records which have a date equal or smaller to two month prior to todays date!
HTH
Good luck
nikb3522
Thank you sir
ik
freakazeud
You're welcome.
Glad we could assist.
Good luck on future projects!
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.