Custom Masking Date Column without Time format

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)).

Tagged:

Best Answer

  • Eddie DEddie D Posts: 1,800 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 
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com

Answers

Sign In or Register to comment.