Calculate the End date of the Month from Start Date
How to Calculate End Date of Month From Start Date in Salesforce?
You need to create a formula field with Date Field Type and use Below formula field
DATE( YEAR(Start_date__c), MONTH(Start_date__c), CASE( MONTH(Start_date__c), 1, 31, 2, IF( MOD( YEAR(Start_date__c), 4) = 0, 29, 28), 3, 31, 4, 30, 5, 31, 6, 30, 7, 31, 8, 31, 9, 30, 10, 31, 11, 30, 12, 31, 0 ) )
0 Comments