Sorry, I may have misunderstood what you were referring to. As for a bit often requested feature, I was referring to the export process that I outlined in my first reply. If you are referring to filtering and IF statements in general, then I wholeheartedly agree that there should be an overhaul on how that works. There are some inconsistencies and limitations with how conditional logic works in Glide. I’ve ran into scenarios where it would have been a lot easier to achieve with actual code. I’ve ranted about it in my feature request below.
As for handling a date range in a filter, I think it’s possible, provided you are using all AND conditions. If you have OR conditions mixed in, then you are stuck with building that logic into the table. Strictly AND or OR logic is quite limiting without being able to mix them. I also know that there are some intricacies when filtering dates. Some conditional operators, such as WITHIN don’t look at the time. I’m also pretty sure that ON OR BEFORE and ON OR AFTER also don’t look at time. They only look at date, ON is only a split second moment that a date and time could match. I think BEFORE and AFTER factor time into it’s compare. I’m not sure it’s even that well documented. Dates in general can get really confusing no matter what. Especially when you are applying formatting on top of them. It’s one of those things I usually have to play with to set it up right.