Hi,
I have made a custom filter control which allows users to select dates by month. I initially had some problems with the month filtering as I couldn't find a way to apply it to more than one month at a time (months may not be consecutive, so I couldn't think of a way to use the greater than/less than filters). I resorted to producing a list of all dates within the selected months and applying an OR filter for each. This works great until I try combine it with filters on other columns (using default filter).
When I apply a filter to a second column, this seems to also be applied as an OR filter. For example, I filter by 'December 2020' in the due date column (custom filter) and Today in the 'Date Entered' column (default filter), I get rows that are due on any date in December OR rows that were entered today. I need to view rows that are due in December AND were entered today.
Normally if I were writing such an expression, I would use brackets:
(DueDate = 01/12/2020 OR DueDate = 02/12/2020 OR DueDate = 03/12/2020 OR ....) AND DateEntered = 30/12/2020
How do I combine the AND & OR filters to get the functionality I need?
Thanks in advance!
