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. |