Query question w/Date

[[email protected]]

I built a query that has the following statement:

FIND Contract WHERE Contract.ContractExpireDate<Current_Date+60 ORDER BY Contract.ContractExpireDate

I have Contract where the ContractExpireDate=9/7/08. The query doesn't return the record. Is there something I am missing?

[tford]

rgates,

See limitation #2 in Appendix B of the User Guide. There is a workaround suggested there.

I always look here first when a query does not work because there are suggested workarounds.

Tom