Reference > Functions reference > Date functions > Month
 

Month

Returns a number from 1 to 12, representing the month of the year in which a date occurs.

Format 

Month ( date )

Parameters 

date - any calendar date

Data type returned 

number

Originated in 

FileMaker Pro 6.0 or earlier

Example 1 

Month ( "3/19/2019" ) returns 3. This example assumes that the operating system date format is set to MM/DD/YYYY.

Example 2 

Month ( Payment ) returns 3, where Payment contains March 19, 2019. (The Payment field must be of type date.)

Example 3 

Returns Bill Due by: followed by a value that is one month later than DateSold.

"Bill Due by: " &
Date (
   Month ( DateSold ) + 1 ;
   Day ( DateSold ) ;
   Year ( DateSold )
)

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas