YEAR( ) Returns the four-digit year value for a specified date value. Syntax YEAR(date) date The date or date expression from which you want to extract the year part. Returns The number that represents the four-digit year for the specified date value. Example The following example gets the four-digit year for each date value in the ShipDate data field, and adds 15 to the four-digit year. For example, if the ShipDate value is Sep 16, 2008, YEAR( ) returns 2023. (YEAR([ShipDate]) + 15)
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy