Code: Select all
[{'Forecast Live','Final Capital Plan','Workplan-Latest','Capital Plan Workspace','Capital Plan Snapshot'},{'Stage 1','Stage 2','Stage 3','Stage 4','Stage 5'},{'Start Date','End Date'},'String'] = S:
IF(DB('Capital - Reporting',!Capital - Reporting Version,!Capital - Projects,!Capital - Reporting Cost Category and Attributes,!Capital - Reporting Time,'Numeric') = 0
,''
,IF(TimVl((DB('Capital - Reporting',!Capital - Reporting Version,!Capital - Projects,!Capital - Reporting Cost Category and Attributes,!Capital - Reporting Time,'Numeric')+7095),'M')<10
,'0'|STR(TimVl((DB('Capital - Reporting',!Capital - Reporting Version,!Capital - Projects,!Capital - Reporting Cost Category and Attributes,!Capital - Reporting Time,'Numeric')+7095),'M'),1,0)
,STR(TimVl((DB('Capital - Reporting',!Capital - Reporting Version,!Capital - Projects,!Capital - Reporting Cost Category and Attributes,!Capital - Reporting Time,'Numeric')+7095),'M'),2,0)
)|'/'|
IF(TimVl((DB('Capital - Reporting',!Capital - Reporting Version,!Capital - Projects,!Capital - Reporting Cost Category and Attributes,!Capital - Reporting Time,'Numeric')+7095),'D')<10
,'0'|STR(TimVl((DB('Capital - Reporting',!Capital - Reporting Version,!Capital - Projects,!Capital - Reporting Cost Category and Attributes,!Capital - Reporting Time,'Numeric')+7095),'D'),1,0)
,STR(TimVl((DB('Capital - Reporting',!Capital - Reporting Version,!Capital - Projects,!Capital - Reporting Cost Category and Attributes,!Capital - Reporting Time,'Numeric')+7095),'D'),2,0)
)|'/'|
STR(TimVl((DB('Capital - Reporting',!Capital - Reporting Version,!Capital - Projects,!Capital - Reporting Cost Category and Attributes,!Capital - Reporting Time,'Numeric')+7095),'Y'),4,0)
)