While working with date filters it seems there is no option to take an open interval starting at date - x until and including today. If one selects past x days, it will end on yesterday.
Can this be added to the options? would translate in sql to the same as the “last x days” except for not deducting a 1 day interval from now() in the between part of the where clause.