month - script and chart function
This function returns a dual value: a month name as defined in the environment variable MonthNames and an integer between 1-12. The month is calculated from the date interpretation of the expression, according to the standard number interpretation.
The function returns the name of the month in the format of the MonthName system variable for a particular date. It is commonly used to create a day field as a dimension in a Master Calendar.
Syntax:
month(expression)
Return data type: integer
Example | Result |
---|---|
month( '2012-10-12' ) |
returns Oct |
month( '35648' ) | returns Aug, because 35648 = 1997-08-06 |