Date range for entire month (v1.5)

Sagan (6 posts)
April 5, 2016 11:40 PM
Accepted Answer

Is it possible to have the data parameters from the first day of the previous month, to the last day of previous month in v1.5?

A report I'm trying to automate has two parameters (start date) (end date) and I currently have this:

"{-1m:01/MM/yyyy} 12:00:00 AM" "{01/MM/yyyy} 12:00:00 AM"

It works well enough, however the report shows the date range, and for example will show (01-Mar to 1-Apr). Ideally I'd like to be able to have the parameter go from the first to the last day.

Bill Staff (602 posts)
April 6, 2016 06:24 AM
Accepted Answer

There's no way to do this in version 1.x, but it can be done in version 2 using date functions.

Two workarounds for version 1:

  • Modify your report to accommodate the date (calculate the end of the month in the report, for example).
  • Run Report Commander from a script (PowerShell, for example) that calculates the dates and sets the parameters for Report Commander to pass to the report.
Sagan (6 posts)
April 6, 2016 03:44 PM
Accepted Answer

Absolute genius Bill, I didn't think of that.

And yeah, I think I'm going to push to have us update to the latest version.

Replies are disabled for this topic.