Last Weeks Dates! 1

[Gojira999]

I have built a query that finds the a table entry with todays dat using date(). So far so good.

What I also want to do is have the query find entries for 7 days ago, 14 days ago & 28 days ago. I tried doing this by adding an OR date()-7 etc criteria. This didn't work. So I tried DateAdd("d",-7,Date()). This didn't work either.

The relevent SQL command is:

WHERE (((Table_WorkReturnsProject_ret.Date)=Date() Or (Table_WorkReturnsProject_ret.Date)=DateAdd("d",-7,Date())));

Any advice would be gratefully consumed!

Thanks.

 

[SuicidED]

Hi
SELECT Table1.Whatever
FROM Table1
WHERE (((Table1.Whatever)=Date() Or (Table1.Whatever)=Date()-7));
etc

 

[PHV]

And what about this ?
WHERE (Date()-Table_WorkReturnsProject_ret.Date) IN (0,7,14,28)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SuicidED]

Nice one PHV

 

[Gojira999]

Thanks all. Much appreciated