Forum Discussion
Determining Gaps between Dates
Hello, I am trying to determine start and end dates of a range that act as a "gap" between when a room is occupied. So, a room would be occupied from a start to an end date. However, after the ...
Hello,
I have seen a solution to this before at the below link:
Just make sure you note there are two parts to the answer in different replies. The first requires you to use M Code to make a partition index by room number.
Then the second creates two calculated columns, one for previous date end, and one for the date diff.
Good luck