Solved
Date filter to select between two fields
In my table, each record has a date range denoted by two fields. I would like the user to be able to use a date filter to select any day within the range and have that record be selected.
Example:
Pointing to this four-field table, the user could choose 04/06/24 in a filter in order to see this record. I realize I could create another table such that this record repeats 25 times, once for every day in between (a record for 4/1, 4/2, ... 4/25). However, my original table is already pushing the limits of being too large; creating that alternative table would be severely impractical.
Any ideas how to accomplish this?
~ Linux/on-prem ~
