Description of problem: Date range in some reports queries is incorrect - includes the end date. The date range should be from the starts date (included) till the end date (excluded). Version-Release number of selected component (if applicable): How reproducible: Example query report currently: AND history_datetime >= CAST ( $P{P_Start_Date} AS TIMESTAMP ) AND history_datetime <= CASE .. Should be: AND history_datetime >= CAST ( $P{P_Start_Date} AS TIMESTAMP ) AND history_datetime < CASE .. Actual results: The date range is from the starts date (included) till the end date (included). Expected results: The date range should be from the starts date (included) till the end date (excluded). Additional info: Report for example: br46
Reports fixed in this bug: BR18, BR19, BR17, BR7, BR8, BR13, BR46, BR16, BR10A, BR22B, BR22B, BR18A, BR23, BR6B, BR4, BR11, BR7A, BR14A
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHEA-2015-0176.html