Hi, created a Case like below:
case
when `All File Dates` >= `EncounterDate` then 'Probable'
else 'Obtain Op Note'
end
This doesn't work to full capacity because the dates in the "All File Dates" column are in no real order. See below highlighted row. The output for Op note on file should say 'Probable' because the encounter date is less than 2022-08-04 but the case statement apparently is only reading the first date.
In ETL, I had converted the date range to text so I could group them together in 1 row.
Any idea how I can compare the encounter date to the all file dates column and have it look at all dates?