NOTE: Two-digit values for the year that are older than 80 years from the current year are forward-ported into the future. For example, in a job run on Dec 31, 2021, the date 01/01/41 is interpreted as 01/01/1941. However, if the job is run the next day (January 01, 2022), then the same data is interpreted as 01/01/2041. As a workaround, you can use the DATEFORMAT function to reformat these dates as four-digit values (01/01/1941). See DATEFORMAT FunctionFor more information including workarounds, see Datetime Data Type.