Date comparison/specific order

[JamesCopeland67]

Objective: Compare sequence of dates that date 1 has to be the furthest out and date 6 the earliest and return any errors.

example:

Record 1 no issues

Record 2 no issues but missing data

Record 3 Date 4 is an issue

Record 4 No issues except no data in Dates 4, 5, and 6

Record 5 No issue except dates 5 & 6 are the same

[atcodedog05]

Hi @JamesCopeland67 

Can you provide the expected output?

[JamesCopeland67]

just need to return as in record 3 that date 4 is an error and record 5 the dates in 5 & 6 match which is also an error

[JamesCopeland67]

in other words adding a column that says "is it good" yes or no and if no where the error is