Best way to calculate dates in a BAQ Report

I am running a report as a BAQ Report and added the date range into the Option Field for a start date and end date. I need to know how many days the user is selecting to do some calculations in the report. What would be the easiest way to go about this? Should I be finding the date range a differently or is there a way to find the date range from what I am looking at?

You can use the DateDiff function within your RDL if you don’t need the number before the report is printed. If you need the number before printing the report you could customize the print form and calculate the number there and pass it to the report using CallContextBpmData.

1 Like