When trying to parse something like 19.10.93 the result is in 2093 - even when setting the reference time to be before 1993. This is due to how ruleDDMMYYYY handles two digit years. It should probably not "hard move" them to the 21st century but rather use some cutoff year within the century of the reference time.
Let the reference year be ccyy (e.g. 1983 => cc=19, yy=83).
Then any two digit year between 0 and yy+10 is interpreted to be within the century cc (e.g. 83 maps to 1983, 93 to 1993), anything above maps to the previous century (e.g. 94 maps to 1894).
In 2019 this would mean that anything up to 29 maps to 20xx, 30+ would map to 1930+
When trying to parse something like
19.10.93
the result is in2093
- even when setting the reference time to be before 1993. This is due to howruleDDMMYYYY
handles two digit years. It should probably not "hard move" them to the 21st century but rather use some cutoff year within the century of the reference time.This is how Excel handles this: https://docs.microsoft.com/en-us/office/troubleshoot/excel/two-digit-year-numbers
Suggestion:
ccyy
(e.g.1983 => cc=19, yy=83
).