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 )