Function: Year
Description
Returns the year portion of a date. Valid range is 1601-2400.
Syntax
Year(date)
Arguments
date can be a constant, a date field, an expression that results in a date or a function that returns a date.
Return value
This function returns a number in the range 1601-2400.
Calculated field example
If the Ship_date field contained the value 19920801, the following calculated field expression would return 1992: Year(Ship_date)
Filter/Find example
Records with a Ship_date field value of 19940303, 19940601 or 19940217 can be selected or found using the expression: Year(Ship_date)=1994
© 2024 Altair Engineering Inc. All Rights Reserved.