Returning records in the past 90 days

  • Thread starter Thread starter Evan M
  • Start date Start date
E

Evan M

Hello,

I am writing a query that i would like to return all results older than 90
days. I thought i was doing well, but i found out that it only returns the
records that are exactly 90 days in the past, not any further. My code is

DateAdd("d",>90,Date())

but I get a datatype mismatch error, which i think is in reference to the
">". can anyone offer suggestions? I would appreciate it greatly.

Thanks,
Evan M.
evan AT radiologyonesource.com
 
Evan said:
I am writing a query that i would like to return all results older than 90
days. I thought i was doing well, but i found out that it only returns the
records that are exactly 90 days in the past, not any further. My code is

DateAdd("d",>90,Date())

but I get a datatype mismatch error, which i think is in reference to the
">". can anyone offer suggestions?
Click to expand...


The criteria for the date field should be:

< DateAdd("d", -90, Date())
 
Back
Top