Delphix Products

 View Only
  • 1.  Using Date Shift to mask varchar field...

    Posted 12-27-2017 03:21:00 PM
    Using the Date Shift(Discrete) algorithm, I need to mask a varchar field that has the data in MM-DD-YYYY format, but that is not a date format available when doing the inventory. Is there a way I can add a new date format (ie MM-DD-YYYYY) to the default algorithm?

    Thanks,
    Renee Note: This conversation was created from a reply on: Description of Date Shift default algorithms.
    #Masking


  • 2.  RE: Using Date Shift to mask varchar field...
    Best Answer

    Posted 12-28-2017 02:24:00 PM
    Hi Renee,
    Yes, you can provide your own Date formats to the algorithm, they should follow normal conventions, you can click the (?) help button to see details.


    Please let me know if you need anything else.
    --Hims


  • 3.  RE: Using Date Shift to mask varchar field...

    Posted 12-28-2017 03:17:00 PM
    I did not realize we could type in that Date Format field. Works great. Thank you!

    Renee


  • 4.  RE: Using Date Shift to mask varchar field...

    Posted 04-30-2020 10:44:00 AM
    Hello Sir,

     I do  have  a same requirement as Data  value which is in Varchar data type and the format is  DDMMMYYYY HH:MM:SS. I tried using with the DATE SHIFT(DISCRETE) with DDMMMYYYY HH:MM:SS format,but it doesn't work. any suggestion please.

    Thanks In Advance



    ------------------------------
    GEETHANJALI DEVI
    Business Objects Developer
    Genworth Financial
    ------------------------------