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

  • 0
  • 1
  • Problem
  • Updated 2 years ago
  • Solved

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.

Photo of santosh kumar

santosh kumar

  • 800 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Hims

Hims, Employee

  • 2,592 Points 2k badge 2x thumb
Official Response
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.