I have two queries in which i need date criteria. The first Im wanting only records from 60 days ago til the present. And the other query I'm wanting from 9/10/2010 til now. What do I put in the criteria field? Thanks.
Advanced Beginner
Windows 7 
Access 2007
I have two queries in which i need date criteria. The first Im wanting only records from 60 days ago til the present. And the other query I'm wanting from 9/10/2010 til now. What do I put in the criteria field? Thanks.
Who is John Galt?
Windows XP Access 2007
Between Date() - 60 And Date()
Between #9/10/2010# And Date()
Posting Permissions
Reply With Quote