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 ) ) )
ExecuteSQL ( "
SELECT COUNT (InterfaceName), InterfaceName
FROM Service_Management
WHERE Date_Created < ? AND
Date_Created > ?
GROUP BY InterfaceName
ORDER BY 1 DESC"
;Char (9) & "- " ; "" ; $EndDate ; $StartDate )
Global date fields can be used in place of the variables. If you use variables be care not to get data typed as text.