Forum Discussion
Using date operators in advanced search
Hello,
you can use AutoFilter to add filter functionality to your table. Then set a filter on the Start date column and show only cells that are greater or equal to the desired start date. Next, set a filter on the End date column to show only cells that are greater to or equal to the desired end date.
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.
