This seems pretty basic, but for some reason I don’t see an easy solution.
I have a table with a date field, and I simply want the user to be able to select a month from a drop-down list, and see the relevant records from that month. For example, user can select “January 2024”, and the table will show only records with the date field witihn January 2024.
In the preset filters for a date fields I only see relative references to the date (“current”, “next”, etc.). I’m sure there’s something I’m missing here…
PS I know the user can create a filter and choose “after”, select January 1st, and “before” and select January 31. But I want to save him the hassle, and simply allow him to choose a month and see the results.
PPS I can create the filters myself, which I will do if there isn’t something easier.