I have two controls on a table. One control is a select for Active, Expired, All. It filters the table based on a check box column. It works just fine by itself.
The second one is a date selector tied to the expiration date in the table. It also works just fine by itself.
I have these same two exact things on another table. I copied and pasted them from the other table, updated all the names. On the other table when I put both filters on I can filter by status and dates. Everything I select works fine.
But in this new table both filters work independently and do exactly as they should. But when both are put together with AND then they do not work right. It is completely ignoring one of the filters.
Ideas? How do you troubleshoot something that works by itself but refuses to work when each filter is added separately and joined with AND?