Hello,

I've discovered rows in STOCK_TRAN where the "Sage Line 50 v33" ODBC driver is returning null from RECORD_CREATE_DATE.
Interestingly and scarily, they're part of a batch where some of the rows DO have RECORD_CREATE_DATE populated....

I cannot seem to query for them.

These return no rows:
SELECT * FROM STOCK_TRAN WHERE RECORD_CREATE_DATE IS NULL
SELECT * FROM STOCK_TRAN WHERE RECORD_CREATE_DATE='1899-12-30'
SELECT * FROM STOCK_TRAN WHERE RECORD_CREATE_DATE='1900-01-01'
SELECT * FROM STOCK_TRAN WHERE RECORD_CREATE_DATE='1970-01-01'

These return an error
SELECT * FROM STOCK_TRAN WHERE RECORD_CREATE_DATE=''
SELECT * FROM STOCK_TRAN WHERE RECORD_CREATE_DATE=0
Microsoft OLE DB Provider for ODBC Drivers. Description:Cannot convert non-numeric data

This does not show them
SELECT TOP 10 * FROM STOCK_TRAN ORDER BY RECORD_CREATE_DATE,TRAN_NUMBER DESC

Any suggestions ?

Thank you

Chris