MONTH()

MONTH() returns the month portion of a specified DateTime as a number.

Use MONTH() to isolate the month portion of a DateTime.

Function Format

MONTH(D)

MONTH() returns a numeric value denoting the month portion of a DateTime.

If the DateTime is purely a time or is invalid/ blank, then MONTH() returns a zero value.

Valid dates are in the range January 2, 1900 to December 31, 9999.

Examples

Using a date of August 14, 2012:

MONTH(‘20120814‘) = 8