This content has been marked as final. Show 2 replies
ExecuteSQL Statement to Select Quantity Ordered
From ORDERLINE_fromOrderHeaderLineCreation o
Join GENERALORDERHEADER g on (g.Id = o.FK_OrderId)
Where (g.DateFinalized ≤ ? and g.DateFinalized ≥ ?)"; ""; ""; SYSVariables::EndDate; SYSVariables::StartDate)
This is my SQL statement I am trying to execute to select the number of products purchased between two dates. I am given the result "?". Any idea as to what I messed up here?
Thanks for the help!