Date range filtering on portlets excludes the date specified on the From or To Date

Document ID : KB000007158
Last Modified Date : 25/04/2019
Show Technical Document Details
Issue:

Steps to Reproduce:
1. Go to any portlet that contains the start and finish dates on the filter section.
Home > General > Project Dashboard tab > Schedule Dashboard portlet.
2. Go to Option > Configure > list filter section > layout and add 'Start'/'finish' to selected column
4. Now go to filter fields, open 'start' properties and change Display type to 'Date Range' and click on save and return.
Do the same with the finish date
5. Check the Start and Finish Dates of any of the projects listed, ie 6/1/17 till 9/14/17
6. Filter Start Date Range 6/1/17 till 6/1/17 or Finish 9/14/17 till 9/14/17

Expected result: Projects with the above dates to be filtered
Actual result: Projects are excluded and only included if we filter as Start Date Range 6/1/17 till 6/2/17 or Finish 9/14/17 till 9/15/17

Environment:
CA PPM 15.x
Cause:

This is caused by DE34134.

Resolution:

After review of the Defect and its root cause, SE (Sustaining Engineer) decided this won't be modified.

As a workaround:
If start (or finish) date is going to be same for a range, there are two simple workarounds  -
1) do not select anything in end part of the range, rather just select date in start part
2) or select the next day in end part