monthname

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.

  • To return the full name, use true, which is the default value.
  • To return the three-character abbreviated name, use false.

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)