9 Replies Latest reply on Jul 25, 2017 4:55 PM by user19752

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

    xxx202xxx

      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 ) )