AnsweredAssumed Answered

Execute SQL (date clause) is not working.  Don't understand why.

Question asked by xxx202xxx on Jul 25, 2017
Latest reply on Jul 25, 2017 by user19752

My query comes back with no data, not even a question mark.  I have a timestamp field called time_resolved that records when a ticket gets resolved.  I am trying to pull all of the records that was "resolved" within the past 48hrs.  No Luck.

 

 

ExecuteSQL("

SELECT Ticket_ID, Location, Network, IncidentSummary
FROM Service_Management
WHERE Status IN (?)  AND Priority=? AND Time_Resolved=?

 

"; " - " ; "" ; "Resolved"; "Critical"; Get (CurrentTimestamp )   ≤  (2 * 24 * 3600 ) )

Outcomes