Report builder Date Ranges

Hmm that sounds like a bug that you can raise with Client Care, but I can offer you an alternate solution.

I haven't actually used any of the Adobe date selectors for years... I actually use the "Dates from Cells" function. In my Excel sheet, I will create a hidden "config" tab, and I will either hard-code my to and from dates into cells, or more often, I will use Excel date functions to create calculated dates relative to "today"

For example, to get Last Month, I use:

=EOMONTH(TODAY(),-2)+1

and

=EOMONTH(TODAY(),-1)

to get "Same Month Last Year" (for comparing to Last Month), I use:

=EOMONTH(TODAY(),-14)+1
and
=EOMONTH(TODAY(),-13)

to get "Year to Date" (not including this month), I use:

=DATE(YEAR(EOMONTH(TODAY(),-1)),1,1)

and

=EOMONTH(TODAY(),-1)

to get "Year to Date, Last Year" (another comparative range to the above), I use:

=DATE(YEAR(EOMONTH(TODAY(),-13)),1,1)

and

=EOMONTH(TODAY(),-13)

With some practice and testing, you can come up with formulas to represent your dates, or again, just put in fixed dates into cells.

The beauty of this is that if I want to run my report for a different time frame, I don't have to edit all my requests... I just have to modify my cells and re-run! Saving me a lot of time and headaches.