Try to run a query on an Access database from Ignition. Wanting to select the previous 5 minutes of records from the listed time. This is what I tried, but having no luck.
[quote]
SELECT logdatetime, head1
FROM logtable
WHERE logdatetime >= DATE_SUB(#2006-10-27 14:59:02#, INTERVAL 5 minute)[/quote]