OK think my issues with Date/Time and Order State filter on SQL queries are both related;
If not its rather coincidental.
They both stop working as soon as a colon is used.
Have tried escaping them with \\
to no avail.
Any suggestions?
OK think my issues with Date/Time and Order State filter on SQL queries are both related;
If not its rather coincidental.
They both stop working as soon as a colon is used.
Have tried escaping them with \\
to no avail.
Any suggestions?
Its the passing them via parameters/@1 as if put inline in the sql.Query it works fine…
function test() {
var test = sql.Query("SELECT SUM([Price] * [Quantity]) as TotalAmount FROM [Orders] WHERE [CreatedDateTime] > '2016-01-03 01:01:01' AND [OrderStates] LIKE '%10003%' AND [OrderStates] NOT LIKE '%PMSPosted%'").First;
return test
}