Hi,

I am using the ODBC to pull transaction history and can pull all of it. However this takes
a bit of time and I really need to only pull certain dates. When trying to use the WHERE
condition, I get the odd error of

[Softrak Systems][SQLEngine] (31750) Column not found: 20180412

Which is the date of my query that I am looking for.

Here is the query string

SELECT Code, Item, TrxDateCode, Detail ,Reference,TrxDate,StockQty,SaleAmt,ExtCost FROM ICTransactionHistory__an92ahaj WHERE ICTransactionHistory__an92ahaj.TrxDateCode="20180412"


Can anyone tell my why this does not work?

Thanks!
Brian