Set the CENTURY_ROLL variable to a 2-digit value to determine the century of a 6-digit date, and then translate it to an 8-digit date.

Any 2-digit year equal to or below than the value of CENTURY_ROLL is determined to be a 21st century data (that is, 20xx), and any 2-digit year above the value is a 20th century date (that is, 19xx).


With the following variable set:


The following dates are translated as such:

Date Translated to
030317 03032017
040449 04041949
050555 05051955