YEAR(date)

Returns the year from a date (Integer).


dateThe date you want the year from (Date).

REMARKS
* If "date" is null, then null is returned
* The "date" can actually be any date, string or numerical expression.
* You can use the DAY function to return the day from a given date.
* You can use the MONTH function to return the month from a given date.
* The equivalent .NET function is Microsoft.VisualBasic.DateAndTime.Year
* For the Microsoft documentation refer to docs.microsoft.com

Year("01/02/2007") = 2007 
Year("1 Feb 2006") = 2006
Year("February 12, 2005") = 2005
Year(Now()) = 2008
Year(256) = 1900

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