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
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
in other words adding a column that says "is it good" yes or no and if no where the error is