Below is my code: I have followed suggestions found on here for date & time difference, yet this one is not working. What's wrong with it?
| from datamodel:"TestTable"
| where scope LIKE "Test%"
| where us_schedule_state like "Accepted"
| where !LIKE(iteration, "%G")
| eval EndDate = strptime(AcceptedDate, "%Y-%m-%d")
| eval StartDate = strptime(trans_to_inprogress_date, "%Y-%m-%d")
| eval DateDiff = tostring((EndDate - StartDate), "duration")
| eval Date = strftime(1533096000.000000, "%Y-%m-%d %H:%S")
| where strftime(StartDate, "%Y-%m-%d %H:%S") > Date
... View more