AnsweredAssumed Answered

Due Dates Reminders

Question asked by AngeloTee on Nov 11, 2012
Latest reply on Nov 12, 2012 by philmodjunk


Due Dates Reminders


     The majority of my customers renew their contracts 120 days before the expiry dates, therefore i have set the calculation to remind me 134 days before the expiry date as shown on attached screen shot.

     However i have a small number  whose contracts need to be renewed 60 days before the expiry dates. I can identify them by the supplier we use called, say ABC in the SupplierField, Supplier. Can someone please help me with the calculation, Would it be something like,

     If(IsEmpty(CED1);Get(CurrentDate) ; CED1 - 134 ) if(Supplier= ABC); Get(CurrentDate) ; CED1 - 60 )