If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information:
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply).
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information:
The above highlights the difference when a value is evaluated during execution as opposed to a constant value. QODBC will lose the jumpin/index capability on the date when you apply a function to it.
If you are looking just for yesterday's transactions, then the TxnDateMacro is the one to use :-
SELECT invoiceline.TxnID FROM invoiceline WHERE TxnDateMacro = 'Yesterday'
or for this month:
SELECT invoiceline.TxnID FROM invoiceline WHERE TxnDateMacro = 'ThisMonth'
As it provides constants relative to the date. Other built-in TxnDateMacro values are :-