Options
Custom Masking Date Column without Time format
vinay11
Posts: 15 New member
Hi Team ,
Need to understand
1.How Only Date Format can be used for masking , since in Data Set i see only "YYYYMMDD HH:MM:SS" I required only "YYYYMMDD".
2. Account Number : I need Dataset to generate Random integer with fixed length 8(INT(8)).
Need to understand
1.How Only Date Format can be used for masking , since in Data Set i see only "YYYYMMDD HH:MM:SS" I required only "YYYYMMDD".
2. Account Number : I need Dataset to generate Random integer with fixed length 8(INT(8)).
Tagged:
Best Answer
-
Options
Eddie D
Posts: 1,780 Rose Gold 5
Hi
Thank you for your forum post.1.How Only Date Format can be used for masking , since in Data Set i see only "YYYYMMDD HH:MM:SS" I required only "YYYYMMDD".Try using the 'Date Variance (Random)' DataSet, for your substitution Rule. You can configure the DataSet to the variance you wish to apply which by default is -53 days for the low bound value and +65 days for the high bound value.2. Account Number : I need Dataset to generate Random integer with fixed length 8(INT(8)).
For this column try using the 'Number, Luhn,Mod(10)' DataSet for your substitution rule. Set the total digits in number to be 8 (by default the value is set to 10).
I hope the above answers your question.
Many Thanks
Eddie
Answers