+ Start a Discussion
mw6mw6 

Set the expiry date for Points

Hi 

We are awarding points for the payments made.  I have a issued date (Points_Issue_Date__c) and Expiry date (Points_Expiry_Date__c). When a record is created in this object (Loyalty_Points__c) 
If the issued date is between 1/12/2016 - 30/11/2017 the expiry date is set as 30/11/2018
If the issued date is between 1/12/2017 - 30/11/2018 the expiry date is set as 30/11/2019
and goes on. In shor I need to set the expiry date is set as 2 years from issue date, but if the issue date goes forward, the expiry date will not change.

Any body can help
Best Answer chosen by mw6
LBKLBK
Here is your formula.
 
IF(Month(Points_Issue_Date__c) < 12, DATE(Year(Points_Issue_Date__c) + 1, 11, 30), DATE(Year(Points_Issue_Date__c) + 2, 11, 30))
Let me know if this works for you.
 

All Answers

LBKLBK
Here is your formula.
 
IF(Month(Points_Issue_Date__c) < 12, DATE(Year(Points_Issue_Date__c) + 1, 11, 30), DATE(Year(Points_Issue_Date__c) + 2, 11, 30))
Let me know if this works for you.
 
This was selected as the best answer
mw6mw6
Hi, Thank you, it worked