Month (Reserved Word)

image\trumpet2.gif Disclaimer

Returns the corresponding month for the specified calendar date. (1 = Jan, 12 = Dec)

Month(cDate)

Where cDate is a numeric expression representing the six or seven digit calendar date in the format YYMMDD or YYYMMDD respectively. (1999 = 99, 2001 = 101)

Examples

Month(990613) returns a value of 6 because 990613 represents June 13, 1999.

Month(1011220) returns a value of 12 because 1011220 represents December 20, 2001.