How can we help you today? How can we help you today?

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

vinay11
0

Comments

2 comments

Sort by
  • Eddie D
    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 D
    0
  • vinay11
    Thank you so much ..will apply this rule
    vinay11
    0

Add comment

Please sign in to leave a comment.