msmerry
asked on
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
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
ASKER
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
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
Do you mean within the last 180 days or more than 180 days ago?
Kelvin
Kelvin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
MAny thanks - always beneficial to come to EE
<DATEADD("d", -180,DATE())
Kelvin