Report Designer Date Value + 24 hours

1 Answer 13 Views
Report Designer (standalone)
Aaron
Top achievements
Rank 1
Aaron asked on 03 May 2021, 09:56 PM

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?

 

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 06 May 2021, 12:44 PM

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

Тhe web is about to get a bit better! 

The Progress Hack-For-Good Challenge has started. Learn how to enter and make the web a worthier place: https://progress-worthyweb.devpost.com.

Tags
Report Designer (standalone)
Asked by
Aaron
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or