T TheHub Registered User. Local time Today, 06:34 Joined Jun 22, 2012 Messages 30 Dec 19, 2013 #1 I am stuck trying to query a table for entries in a date field that are 21 days earlier than the current date. I thought I could use the built in 'Now()' but am struggling. Any pointers would be helpful :banghead:
I am stuck trying to query a table for entries in a date field that are 21 days earlier than the current date. I thought I could use the built in 'Now()' but am struggling. Any pointers would be helpful :banghead:
pr2-eugin Super Moderator Local time Today, 06:34 Joined Nov 30, 2011 Messages 8,494 Dec 19, 2013 #2 Try this criteria.. Code: DateAdd("d", -21, Date()) In the Date Column you are trying to filter..
M Mihail Registered User. Local time Today, 08:34 Joined Jan 22, 2011 Messages 2,373 Dec 19, 2013 #3 ... or, maybe, Code: DateAdd("w", -3, Date())
G Geotch Registered User. Local time Today, 00:34 Joined Aug 16, 2012 Messages 154 Dec 19, 2013 #4 Mihail said: ... or, maybe, Code: DateAdd("w", -3, Date()) Click to expand... Won't this exclude anything in that week causing you to exclude records?
Mihail said: ... or, maybe, Code: DateAdd("w", -3, Date()) Click to expand... Won't this exclude anything in that week causing you to exclude records?
T TheHub Registered User. Local time Today, 06:34 Joined Jun 22, 2012 Messages 30 Dec 20, 2013 #5 Thank you. Will try these and respond
M Mihail Registered User. Local time Today, 08:34 Joined Jan 22, 2011 Messages 2,373 Dec 20, 2013 #6 @Geo My post was based only on the "21" value that means exactly 3 weeks.
