HASHDoB() function fails to replace dates on various records

book

Article ID: 200980

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

In TDM Portal, using HASHDOB () function for all DOB fields(VARCHAR type) for masking didn't mask the data. The data field has remained unchanged. 

Cause

Didn't specifying the Date format in HASHDOB() caused the issue.

Environment

Release : 4.9

Component : CA Test Data Manager

Resolution

Specifying the Specific Date format based on the DB in the HashDOB()-->Extra options resolved the issue.

Additional Information

https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/reference/masking-functions-and-parameters.html