Returns the full or abbreviated name of the calendar month for a specified date or time in Salesforce Spiff.
Required Editions
| Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions |
| Available for an additional cost in: Professional Edition with Web Services API Enabled |
Syntax
monthname(date_or_time, abbreviate)
Arguments
| Argument | Required? | Description |
|---|---|---|
| date_or_time | Required | The Date or Date & Time value to evaluate. This argument supports any date functions. |
| abbreviate | Optional |
A Boolean that specifies whether to return the month's full name or abbreviated name.
|
Example
Return the full name of the month for January 31, 2025. The return value is January.
=monthname("2025-01-31")
Return the abbreviated name of the month for January 31, 2025. The return value is Jan.
=monthname("2025-01-31", false)