Forum Discussion
Using date operators in advanced search
That's just the problem. I've tried doing that several times, but I get a zero-row response. It should not be a formatting problem. Maybe I'm using the wrong filter option; what I've been doing is clicking on the column header drop-down arrow and selecting Custom Text Filter. I don't see any other option for <= or >=. When I import the table into Access, I can get it to work perfectly with queries, but Excel should be able to handle this. Can I send you a sample of the table?
If you only see custom text filters, then the data in the column is not dates, but text. If you have real date values in the column, you will see the Date Filters like in the screenshot below.
You will need to convert the text to real dates. How exactly that can be done depends on what is stored in the cells. Please show some samples.