Report Designer Date Value + 24 hours

[Aaron]

I'm using Report Designer 15.0.21.326:

I'm trying to return all transactions that occurred over a single day. When I use a report parameter to choose the date I want to return results for, it only returns results that occurred on the date specified at specifically 0:00:00. To work around this, I have defined an end date report parameter so I am entering a date range of 1/1/2020 - 1/2/2020. My report filter is filtering >= StartDate and < End Date. This effectively filters all transactions for date 1/1/2020.

Is there a way to have one date prompt and set the filter to add 24 hours to the date value that is selected rather than defining a start and end date report parameter?

 

[Todor]

Hi Aaron,

You may use our built-in Date and Time functions AddDays(date, days) or AddHours(date, hours) and provide the StartDate as a first argument and 1 day or 24 hours as a second, correspondingly.

Regards,
Todor
Progress Telerik