Validating the date of the next record

@Aimee Carter here is my solution to solving it. In a transform step, let's create two new columns. The first column is "Previous Effective To" which brings Effective To Date from a previous row into the next one. The second column "Continuous Date for Customer" then compares Effective From and Previous Effective To Dates and returns true if they are both present and the difference between them equal to one. We can then pass true/false values into the validation step to pass or fail the rule.

Here is the function for Previous Effective To date using Get Cell and previous row. We return both "previous row" Customer and Effective To Date and populate the value of the previous date if the customer matches between different rows. There is also some error handling added.

For Continuous Date check, we need to check if both "Effective From" and "Previous Effective To" dates are present and if they are, check the difference equals one day.

Attached the full solution as a dmx. Let me know if it works on a live data as expected.