Formula field to find the last day of the month in Salesforce

Sample Code:

IF( MONTH( TODAY() ) = 12,
DATE( YEAR( TODAY() ), 12, 31 ),
DATE( YEAR( TODAY() ), MONTH( TODAY() ) + 1, 1) – 1)

Leave a Reply