Function reference

Gets the month of a date value.

Month ( date )

Argument Description
date The date from which you want the month

Data type: Integer
Returns an integer (1 to 12) whose value is the month portion of date.

Example 1
This expression returns 1:
Month( Date(‘2005-01-31’) )

Example 2
This expression returns Wrong Month if the current month is not 6:
If ( Month(Today())=6 , ‘June’ , ‘Wrong month’ )

Last modified: 23 May 2021