Thread: Formula Meaning
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bevatron
 
Posts: n/a
Default Formula Meaning

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.