Date fields

[KenB]

I have an issue with datetime fields when used in a filter. I have a field called dinvoice that is a datetime field. I am trying to filter out invoices that are older then 6 months and using the expression _dinvoice >= SUBMONS(DATE(),6)_. This returns a _No Records Found_ when run. I am filtering a FoxPro SQL database.____Tried _TODATE(dinvoice) >= SUBMONS(DATE(),6)_ with the same results.__