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

Sample Formula code:

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

Cheers!!!

No comments:

Post a Comment