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