MONTH

Returns the month from the DateTime value passed to the function. If the date is in wrong format then the function returns the month extracted from system time.

Syntax

= MONTH(value)

Parameters

value

A date time value from which the month has to be extracted. The value can contain DateTime as a string (e.g. “02/19/2009 14:30:30.3”, "2009-02-19 14:30:30.3",

 "19 Feb 2009 2:30:30.3 PM ", "Thu, 19 Feb 2009”) or as a DateTime object.

Return Type

Integer

In the case of an error, the function displays an error message: “MONTH(value): Error message”

Examples

Example

Returns

= MONTH(“02/19/2009 14:30:30.3”)

2

= MONTH("2009-02-19 14:30:30.3")

2

= MONTH(“abcd”)

The month extracted from system time.

= MONTH(ShippedDate)

The month extracted from the value of ShippedDate. If any entries are NULL then returns the month extracted from the system time.