Can you consider creating a date range with fixed start and rolling end? For example - Nov 5 - today or yesterday. For previous period, are you looking for fixed days? For previous period, you can keep end of as fixed day and start as rolling?Current Period- Previous Period-