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 version 

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.

Copy 
"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.

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

Related topics