AnsweredAssumed Answered

Using ExecuteSQL to find Avg Elapsed Time

Question asked by xxx202xxx on Aug 7, 2017
Latest reply on Aug 8, 2017 by user19752

Having trouble with my query. All I get is a freaking ?  Help!

 

ExecuteSQL ("

SELECT AVG (c_Resolved_Elapsed)
FROM Service_Management
WHERE Priority=? AND MONTH(Date_Created)=?"

;" - "; ""; "Critical"; Month ( Get ( CurrentDate ) ))

Outcomes