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

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment