query for items more than 90 days from current date

[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.

 

[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.

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

or more than 90 days into the future?

 

[Guy Story]

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

or more than 90 days into the future?

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

thanks.

Guy

 

[Guy Story]

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

or more than 90 days into the future?

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

Guy