Expands a two-digit year in format YY to a four-digit year, with the returned value in YYYY format.
Y4YEAR (d[, w])
d is a string expression of computational and character type with at least two characters. Characters in excess of two must be formed by leading blanks. If the character type is omitted, it is converted to character by default.
w is an integer expression value of the century window to be used for any two-digit year formats.
Y4YEAR('99',1975) returns '1999'
Y4YEAR('00',1975) returns '2000'
None.
Description
The Y4YEAR built-in function returns a value with the CHAR(4) NONVARYING attributes calculated as follows: