How to resolve Condition Macro issue in CA SDM

[Andy Lam]

Hi all,

I am working on creating a condition macro in CA SDM to trigger an action when current date ("NOW()") is 7 days greater than the Scheduled End Date (sched_end_date) of Change.  However, CA SDM didn't recognize value NOW() or function to calculate NOW() - 7 DAYS.  I have also tried to use function DATEADD or DATEDIFF but SDM returned "unknown function" for them.

Any guidance or examples of how to implement this logic would be greatly appreciated.  Version of CA SDM using in my site is 12.9. 

Thank you in advance for your help.

------------------------------
Best regards,

Andy
------------------------------

[Andy Lam]

Case closed.  Thank you.