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.