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