Returns the year from a date (Integer).

dateThe date you want the year from (Date).

* 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

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

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