It has to be thirty days from the date the document was logged in with a null
date logged out.

"Dave Peterson" wrote:

Are you sure it isn't:

someexpression <=Today()-30

=today() is a worksheet function that takes no parms. You don't put anything
between the ().

You may see it with =now(), too.



Bevatron wrote:

The following formula, <=Date()-30, produces a query telling me which
documents in my database have been in my office for review for longer than 30
days. They are dated in and dated out, and when I date them out they
disappear from my "Over 30 Day List". I didn't create this particular query
myself, and I don't know what the () represents. I understand greater than
and equal to. Since the result is documents OVER 30 days, the -30 is
puzzling to me as well. Any help would be greatly appreciated.

--

Dave Peterson