Delphix Products

Back to discussions
Expand all | Collapse all

How to modify "DATE SHIFT(FIXED)" algorithm to reflect increment by 1 day, instead of 5 days

  • 1.  How to modify "DATE SHIFT(FIXED)" algorithm to reflect increment by 1 day, instead of 5 days

    Posted 06-27-2017 03:00:00 PM

    I have a need to mask the DOB, by incrementing 1 day, except last day of the month. Example:

    If DOB is between 1-29, increment by 1 day

    If DOB is 30, decrement by 1 day

    Current logic of DATE SHIFT(FIXED) method is, increment 5 days when DOB is 1-25

    If DOB is 26th then increment again by 5, but retain the same month, like 1st April

    Please suggest, how to achieve this.


    #Masking


  • 2.  RE: How to modify "DATE SHIFT(FIXED)" algorithm to reflect increment by 1 day, instead of 5 days
    Best Answer

    Posted 06-27-2017 03:23:00 PM
    Hi Santosh,
    There are many ways to mask dates in Delphix, if you want a custom date shift/variance, You can import an algorithm to do so. If you are a Delphix Customer or prospect; Please get in touch with Delphix Representative / ADR and we can help you with all your requirements. 
    Alternatively you can attach a SQL to a job as a pre/postscript to achieve this.

    --Hims