Analysing dates values placed in different rows

Marco_13112001Marco_13112001 Contributor
edited August 31 in General discussion

Good morning,

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.





01-Jul-2022 00:00:00.000Z[UTC]

02-Jul-2022 00:00:00.000Z[UTC]


01-Jan-2023 00:00:00.000Z[UTC]

31-Mar-2023 00:00:00.000Z[UTC]


01-Feb-2023 00:00:00.000Z[UTC]

03-Jul-2029 00:00:00.000Z[UTC]

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.

Best Answer


Sign In or Register to comment.