Project and Portfolio Management Practitioners Forum
cancel

Date Period Calculations Table PM_PROJECTS

SOLVED
Go to solution
Highlighted
rgonsatx
Contributor.

Date Period Calculations Table PM_PROJECTS

Hi All -

 

I was able to create a custom portlet however i'm confused by the state date period / finish date period. These are not normal dates, is there a way to calculate what the correct date is based on the period?

1 REPLY
Erik Cole
Acclaimed Contributor.
Solution

Re: Date Period Calculations Table PM_PROJECTS

The periods in PPM_PROJECTS are foreign key references to period_id in PPM_FISCAL_PERIODS. You should be able to join to that to get start/end dates.