Creating a time schedule

[Jean_Pierre_Traets]

Dear @Ruby_George,

This post should guide you in the right direction:

Simple thing I can't work out

@Josh_Unwin1, @Ander A word of caution for the solution - that solution works only if rows were created in order. If you have rows created out of order - you might want to actually pick the record with highest end date that is earlier than current records’ start date. here’s a document that shows results with both approaches and you can see when rows are created out of order- you might get odd results.