Analysing dates values placed in different rows
I'm trying to build a logic that will compare two date values and returns the comparison as a positive or negative number, the restriction is that the check has to be done within a group that have the same ID number. However, both date values are not on the same column or row (see example below).
The idea is to "flag" any start date that happens earlier than the end date of the previous row.
I've used in the past the function compare date/time to perform the comparison but for values that were in the same row.
Is there any out of the box function that can be used on this case?
Many thanks in anticipation.