Project and Portfolio Management Practitioners Forum
cancel

Defaulting a date value

Highlighted
Ryan Grobler
Super Contributor.

Defaulting a date value

Hi ALl

I want to pull through a list of Projects which were cancelled between 2 dates, at the moment this date is only stored in the project audit trail, but I want to add this field into the project details so I can add it to a dashboard.

I have created a date field which uses the rule: SELECT "[SYS.ITG_TIME_STAMP]","[SYS.ITG_TIME_STAMP]" FROM DUAL when the 'Status' field has a certain value (Project Closed (Stopped) - but this doesnt seem to work well.

Is there a better way to default this date field to show me the date the project was stopped?
2 REPLIES
Sascha Mohr
Acclaimed Contributor.

Re: Defaulting a date value

Does "select sysdate, sysdate from dual" work?
Raj Ghimire
Outstanding Contributor.

Re: Defaulting a date value

Not completely sure about your schenario but would using a Execution step command help your situation ?
We are using a Execution Step to populate when the Project was Completed using workflow step command:

ksc_store PRJ_COMP_DT="[SYS.ITG_TIME_STAMP]"