Saved search to calculate time elapsed from system notes

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)

Leave a comment

Your email address will not be published. Required fields are marked *