Reference > Functions reference > Date functions > MonthName
 

MonthName

Returns the full name of the month for a date.

Format 

MonthName(date)

Parameters 

date - any calendar date

Data type returned 

text

Originated in 

FileMaker Pro 6.0 or earlier

Example 1 

MonthName ( "6/6/2019" ) returns June.

Example 2 

Returns Payment due by the end of May, where InvoiceDate is 4/4/2019.

"Payment due by the end of: " &
MonthName (
   Date (
      Month ( InvoiceDate ) + 1 ;
      Day ( InvoiceDate ) ;
      Year ( InvoiceDate )
   )
)

Example 3 

Returns Payment for: followed by the name of the month that is one past the month of the last payment.

"Payment for: " &
MonthName (
   Date (
      Month ( Payment ) + 1 ;
      Day ( Payment ) ;
      Year ( Payment )
   )
)

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas