AnsweredAssumed Answered

Dynamically add a date range to an ExecuteSQL

Question asked by xxx202xxx on Dec 4, 2017
Latest reply on Dec 4, 2017 by philmodjunk

Looking for any information to see if what I am asking for can be done.

 

Below is a query that I have that will list the amount of a given interfaces for the entire year.  But what if I want to find this information by allowing the user to insert the date range.  Will it be possible to insert a date range into said query?  If I am looking at this the wrong way any suggestions?

 

ExecuteSQL ( "

SELECT COUNT (InterfaceName), InterfaceName
FROM Service_Management
WHERE YEAR(Date_Created)=?
GROUP BY InterfaceName
ORDER BY 1 DESC"

;Char (9) & "-   " ; "" ; Year ( Get ( CurrentDate ) ) )

Outcomes