Hi all,

In the Ad-Hoc reports, I ask the user for a date range for the report (Filter). Does anyone know how to capture the dates (Between) and display them on the report?

Gary

Hi Gary,

At first, you should select the field which is the date and then from the drop-down menu select the option 'in between'.

 

Thank you Chris,

I can choose the proper dates for a report. What I want to do is print the dates chosen on the report.

Something like this in that report header.

"Service Work Detail from March 1, 2018 through March 15, 2018."

Gary

You can add something like this:

=Concatenate("report for the period ", AggMin({Tickets.Open Date Only})," till ",AggMax({Tickets.Open Date Only}))

Also, you can select the field from the spreadsheet and create the function

Hi CHris,

Thank you for the help with this.  To help others out, I am posting what I actually used.  I was trying to print filter choices on a report, so I used the following.

=Concatenate(FilterValue(1,1)," - ",FilterValue(1,2))

From Filter

From Report

Edited May 3, 20187 yr by Gary Haberl