HI I am running Pervasive SQL 9.1 and am just trying to run a a query that grabs all transactions between now and 4 months ago. This query is run as an Access pass-through query. Is there a dateadd function or something in 9.1?
My attempt is the following
SELECT * FROM order where docdate > CONVERT(CONVERT(CURRENT_DATE(),SQL_INTEGER)-150)),SQL_DATE)
I get errors about a restricted data type attribute violation or something. Anybody have any ideas?
My attempt is the following
SELECT * FROM order where docdate > CONVERT(CONVERT(CURRENT_DATE(),SQL_INTEGER)-150)),SQL_DATE)
I get errors about a restricted data type attribute violation or something. Anybody have any ideas?