Expand my Community achievements bar.

SOLVED

Report builder Date Ranges

Avatar

Level 1

For the past 2 days I haven't been able to update fixed date ranges in report builder. The calendar pop-up spins forever and never opens up.

I have downloaded and reinstalled the most recent version of report builder.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor and Adobe Champion

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.

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor and Adobe Champion

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.

Avatar

Level 2

Hi

 

Has your problem got resolved? I am also facing similar problem for the last couple of weeks and still unable to figure out the solution.


Regards
Roy