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?
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: