Finish date of PPM Idea is showing in INV_INVESTMENTS as one day later

Document ID : KB000117890
Last Modified Date : 19/10/2018
Show Technical Document Details
Issue:
The Finish Date of CA Project & Portfolio Management (PPM) Ideas are showing in the SCHEDULE_FINISH field in the INV_INVESTMETNS table as one day later then what is set in PPM.

Steps to Reproduce:
  1. Create a new idea in PPM 
  2. Set the Start Date of the idea as 01/03/2018 and Finish Date as 05/17/2018
  3. Run the below query and make a note of schedule_finish date 
select id, name, schedule_start, schedule_finish from inv_investments where id = < > 

Expected Results: Schedule finish date should be same in UI and database (05/17/2018 in the above example)
Actual Results: Schedule finish date always show as 1 day advance in the database (shows as 05/18/2018 in the DB)
Resolution:

This was reviewed by our Sustaining Engineering team as CLRT-59397 and determined to be working as expected. 

  • The date stored in the database is +1 day because Idea's Finish dates default to a "midnight" date. 
  • However, in the case of projects, the date also has a time component. For example a project's finish is usually 5pm, so then the date in the database would match what you see in the UI. In this case the date doesn't represent 'midnight' and therefore isn't +1 day.

Workaround: Change the end time of the Idea Finish Date field to be earlier then 12:00 am, then the PPM UI and DB will match. 
To do this:

  1. In PPM, go to Home->Ideas
  2. Click on Options then Configure
  3. Move Finish Date to ‘Selected Columns’ if not there already
  4. Click Save
  5. From the 'List Column Section' drop down, select ‘Fields’
  6. Click the properties icon next to ‘Finish Date’
  7. In the ‘Date/Time Format Scale’ drop down, select ‘Day Time’
  8. Click ‘Save and Return’ then click ‘Return’
  9. In the Finish Date field, change the Time of the Idea from 12:00 AM to an earlier end time such as 5:00 PM, then click Save.