Hi, everyone! I’m trying to calculate a Membership End Date — which should always be the last day of the month, taking leap years into consideration — based on a Membership Start Date (which is not always the first day of the month).
I know ADDMONTHS will take leap years into consideration, but how can you ensure that the Membership End Date will always be the last day of the month, regardless of the month having 30 or 31 days?
Thank you!
#Formula Help @Steve Molis @Formulas - Help, Tips and TricksThanks, @Steve Molis, as always! :)
I am trying to use this as a Flow formula for both 1 year and 2 year memberships. Here is what I have so far, but I am getting syntax errors when I add the ADDMONTHS part. :( Any help is much appreciated -- thank you!
IF( OR( ISPICKVAL({!$Record.Member_Level__c}, "1 yr membership"), ISPICKVAL({!$Record.Member_Level__c}, "2yr membership)") ),ADDMONTHS( DATE(YEAR( {!Start_Date__c },MONTH({!Start_Date__c }, 01), 13 ) - 1)),ADDMONTHS( DATE(YEAR( {!Start_Date__c },MONTH({!Start_Date__c }, 01), 25 ) - 1)))