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?