This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!
Objective: Compare sequence of dates that date 1 has to be the furthest out and date 6 the earliest and return any errors.
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
Can you provide the expected output?
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