More than 180 days before today's date

ccess 2010
I have an update query where I want to find anyone whose MemberStatus is 1 AND who enquired more than 180 days before today, then update their status to 4.  The date field -DateEnquired - is set to Short Date. The Criteria is <Date()-180.  This returns an error message.
What am I missing?
UPDATE-BASED-ON-DATE.JPG
msmerryAsked:
Who is Participating?
 
Kelvin SparksCommented:
Reading your initial post again it should be

DateEnquired < DATEADD("d",-180,Date()) AND MemberStatus = 1.

Try using it in a select statement until you get the query correct, then use it to make the update statement.


Kelvin
0
 
Kelvin SparksCommented:
Use the DATEADD function
<DATEADD("d", -180,DATE())

Kelvin
0
 
msmerryAuthor Commented:
Thanks Kelvin,
Tried that but it doesn't work.  
I would guess that it is looking for a specific date - exactly 180 days before today - in other words,  take 180 days off today; if there is no such entry, then it returns nothing.

What I want is Find all dates greater than 180 days before today - somewhere it requires <. or is it >?
Aileen
0
 
Kelvin SparksCommented:
Do you mean within the last 180 days or more than 180 days ago?

Kelvin
0
 
msmerryAuthor Commented:
MAny thanks - always beneficial to come to EE
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.