MONTH(date)

Returns the month from a given date (Integer).


dateThe date you want the month of (Date).

REMARKS
* The "date" can be any date, numeric or string expression.
* If "date" is Null, then Null is returned.
* The value returned is between 1 and 12.
* You can use the DAY function to return the day from a given date.
* You can use the YEAR function to return the year from a given date.
* The equivalent .NET function is Microsoft.VisualBasic.DateAndTime.Month
* For the Microsoft documentation refer to docs.microsoft.com

Dim lDate As Date 
lDate = 32616
Month(lDate) = 4
Month(#12/6/2008#) = 12
Month("1 January 2007" = 1
Month("February 12, 2005) = 2
Month("01/02/2007") = 2
Month("1 Feb 2007") = 2
Month(Now()) = 8
Month(1) = 1
Month(15) = 1
Month(30) = 1
Month(32) = 1
Month(33) = 2
Month(60) = 2
Month(61) = 3
Month(256) = 9
Month(365) = 12
Month(2000) = 6

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top