This is a situation that was set up before I arrived on the scene in this company; so, in their old data, they used character dates, a real sloppy way to go in my opinion.
What I am using is a Buffered table in the data environment, but I could change this to an updateable and parameterized View and allow the user to set the date range.
>You can index parameterized view.
>Filters and grids simply don't like each other even after some improvements in VFP9. So just don't use SET FILTER command.
>Also if you would have an index on date field and have it as a date (why do you use char field for dates), then you can simply use
>select * from myTable whhere date between date(year(date()),1,1) and date()
>You actually need to set lower and upper limit as variables, not directly in a query as I showed here.