Have you guys had any issues with <NetSuite2.com> ...
# suiteanalytics
s
Have you guys had any issues with NetSuite2.com when filtering linelastmodifieddate in transactionline?
Copy code
SELECT * FROM  "transactionline" 
WHERE linelastmodifieddate > '2023-06-16 18:50:50';
This throws:
Copy code
SQL Error [400] [S1000]: [NetSuite][ODBC 64bit driver][OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# ll3391jspnrtii312ijr[400]
b
I've had to use to_date() in order to specify a value in a statement.