YEAR (PQL - xl)
This function returns the year as an integer for a specified date
- Library: PQL \ Spreadsheet \ Date & Time
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
- Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions
Syntax
YEAR(serial number)
Function Arguments
Name | Description | Type | Optional |
serial number | Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4) | StringOrNumber |
|
Comments
This function is the same as the Microsoft Excel 'YEAR' function - using the same inputs, logic and outputs.