Query criteria problem

Evenflow

Registered User.
Local time
Today, 13:03
Joined
Apr 13, 2005
Messages
22
Hello. I'm writing a query to show if it is past 7 days of a certain date. The field in my table is SentDate. Lets say a package was sent on 2/1/05. If it is past 7 days from that date, I need the query to show this. I come up with
=Now()>"[Tablename]"!"[FieldName]", I know all this shows is if today is greater than the day sent, but I just need to know where I would add the +7 days line to it, or if I cant add that to this particular line, could anyone give me a hint as to what it would be?
 
Use dateadd function
DATEADD("d",7,[SentDate])
But if you are checking for greater than (>) you may want to use 6, or >= instead.
 

Users who are viewing this thread

Back
Top Bottom