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 ) 
   )
)