query for items more than 90 days from current date

G

Guy Story

I am striking out on this one. I need to be able to run a query that looks
for items that exceed 90 days from the current date. I thought Day()-90
would do the trick but it did not. Any suggestions?


Guy.
 
F

fredg

I am striking out on this one. I need to be able to run a query that looks
for items that exceed 90 days from the current date. I thought Day()-90
would do the trick but it did not. Any suggestions?

Guy.
Click to expand...

Did you want earlier than 90 days from the current date?
< Date() - 90

or more than 90 days into the future?
 
G

Guy Story

fredg said:
Did you want earlier than 90 days from the current date?
< Date() - 90

or more than 90 days into the future?
Click to expand...

days earlier than 90. I will give your suggestion a try and reply back.

thanks.

Guy
 
G

Guy Story

fredg said:
Did you want earlier than 90 days from the current date?
< Date() - 90

or more than 90 days into the future?
Click to expand...

Fredg, I probably tried every iteration except that. Now I feel
foolish. Thanks for the help. Metal block stinks.

Guy
 
Top