Using FDM function, HASHDOB, to mask a column defined as character and containing a date value in the format dd-mmm-yy (eg 12-DEC-55). FDM will properly mask all dates except for dates that end in years from 18 to 37. Running 4.5 but happens on 4.3 as well. Can this be fixed?
TDM 4.5 and TDM 4.3
FDM is the component being used.
Please contact Support for FastDataMasker-4.7.422.0.zip or later. This fix resolves the problem.
Follow-up question: Just curious as to what the cause was. We did think that it was a bit more than coincidence that the problem started with the year 18 being that it was 2018 now. However didn’t understand why only dates from 18 up to 37 were effected. Was it just a simple case of adding 10?
Answer: The java date formatter CA uses interprets 2 year dates like 37 as 2037, since FDM then thinks the birth date is after the current date, it ignores it. This only occurred with string dates, normal dates or datetime was not affected.