Returns an integer representing the year of the specified date parameter.
Year (Date)
Date - (Input, expression, Required)
The date value to extract the year from. If date is specified as a string expression, Newlook will convert it to a date as long as it contains a date in the form "mmm d, yyyy" (e.g. "Feb 1, 1999").
An integer representing the year of the specified date, e.g. 1999, or Error if date is not a valid date.
|
Year ("1 Feb 99") |
Returns 1999 |
|
Year ("29 Feb 99") |
Returns Error |
|
Year (Now ()) |
Returns the current year |
|
Year (Null) |
Returns Error |
|
Year (Error) |
Returns Error |
Functions are specifically for use in the Macro Editor. Refer to Microsoft's official VB and JScript documentation for scripting equivalents.
Date function | DateAdd function | DateDiff function | Day function | Hour function | Minute function | Month function | Now function | Second function | Time function | Week function | WeekDay function
© 2004-2021 looksoftware. All rights reserved.