MAX(CASE WHEN {systemnotes.field} LIKE ‘Problem Order’ AND {systemnotes.newvalue} = ‘T’ THEN {systemnotes.date} END) – MAX(CASE WHEN {systemnotes.field} LIKE ‘Problem Order’ AND {systemnotes.newvalue} = ‘F’ THEN {systemnotes.date} END)
MAX(CASE WHEN {systemnotes.field} LIKE ‘Problem Order’ AND {systemnotes.newvalue} = ‘T’ THEN {systemnotes.date} END) – MAX(CASE WHEN {systemnotes.field} LIKE ‘Problem Order’ AND {systemnotes.newvalue} = ‘F’ THEN {systemnotes.date} END)