1 of 1 people found this helpful
After resolving a similar challenge in Smart Reporting, I have returned to his query with the same solution. Rather than trying to modify the query filter for a time period selection which does not seem to be possible, I found a formula in design mode to use as a filter.
Firstly, create a variable with a formula to extract the hour from Scheduled Start Date Time.
Secondly, create a Filter using that variable to select the hour range between 3 and 6, whch represents the period 3am to 6am.
The records returned then are only those valid for that time period.
Best regards, Conor