Previous Dates

P

Peter

Hi all, i am ashamed to admit that i can not figure this one out..

In one table i have the DateCreated field. In my query i want to display all
records created today, Date() and during the previous two days. If today is
Thursday i also want to see the records created Tuesday and Wednesday and
today..

I am trying this -2<!>=Date() but it fails..

Any ideas?

Thanks!
 
V

vanderghast

< Date( ) + 1 AND >= Date( ) - 2


should do, in the grid., as criteria.



Vanderghast, Access MVP
 
P

Peter

Thank you very much! Indeed it works perfect!

vanderghast said:
< Date( ) + 1 AND >= Date( ) - 2


should do, in the grid., as criteria.



Vanderghast, Access MVP
Click to expand...
 

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

Between dates / Long date format 1
=now () - 90 1
How in Access do I use Date()+2 missing weeknds (e.g Thu+2 = Mon) 2
General Date problem 4
Multiple IIF Statement... 4
Choice of Criteria 2
Using Between...And with General Date 2
Filter criteria for a conditional serialdate field in a query 2

Top