Hi,
I have to write a query. where I need, to utilize the Case Status field and see within the time period of the query(month) when a case status goes from Closed to Active for particular caseID
CASE ID DATE STATUS
ABC 2-Jun ACTIVE
DSA 4-Jun ACTIVE
EDD 4-Jun CLOSED
QDK 3-May ACTIVE
ASD 2-May CLOSED
ABC 4-Jun CLOSED
DAJ 4-Feb ACTIVE
FKD 5-Feb CLOSED
ABC 10-Jun...