Changes

Template / Type Formula

114 bytes added, 21:10, 22 October 2013

no edit summary

* To populate the '''End Date''' standard field with the date the status is changed to '''Complete'''

@level1.enddate@=IF(CASE WHEN "@level1.status@"="Complete" and "@level1.enddate@"="0000-00-00" ,THEN CURDATE(),WHEN "@level1.status@"="Complete" and "@level1.enddate@"!="0000-00-00" THEN "@level1.enddate@" ELSE "0000-00-00")END;

==Using a Level 2 Type Formula==

• ← Older edit
• Newer edit →

0

edits