Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
1. SCAR open in particular month (MTH):
- InitiationDate <= MTH AND
- [ InvestDue <> NULL AND ( InvestComplete = NULL OR InvestComplete >= MTH ) OR
- ( same for ImplementationDate ) ]
to know the timelines as intime....
2. SCAR late in particular month (MTH):
- SCAR open (see above) AND
- [ InvestDue <> NULL AND InvestDue <= MTH AND ( InvestComplete > InvestDue OR Today() > InvestDue ) OR
( same for ImplementationDate
to know the timeliness as past due...
Need the expression for this scenario..