DSXchange

Hello Ray, Thank you for your answer. I should have formulated the question differently. I have not specified the relation between date_start and date. Actually they are closely related: The second status(status2) starts on the day after the transition from status 1 to status 2, which is date1+1: da...

Hello, We have a table giving the transitions between different statuses date1 status1 status2 date2 status2 status3 .... date(n) status(n) status(n+1) We would like to change the table to the form status1 date_start1 date_end1 status2 date_start2 date_end2 .... status(m) date_start(m) date_end(m) I...