Query Data Reader (SET DATE)
Dimas Prayogo
Active Partner
Hello Everyone,
I have a case. Just want to read a Data Reader from Excel data. So i used the ODBC Excel Driver. I used manual query, because want to set a entity with a current date (format 'yyyyMM'). So i used (like picture below) this query like SQL Query, but obtain an error.
Any solution for this case? or what function i can used for manual query from odbc driver.
Thank you,
Best Regards
I have a case. Just want to read a Data Reader from Excel data. So i used the ODBC Excel Driver. I used manual query, because want to set a entity with a current date (format 'yyyyMM'). So i used (like picture below) this query like SQL Query, but obtain an error.
Any solution for this case? or what function i can used for manual query from odbc driver.
Thank you,
Best Regards
0
Accepted Answer
-
Hi Dimas,
it seems, that this is not supported by the ODBC driver. But you can do the same within board etl
Regards
Björn
------------------------------
Björn Reuber
Support Team Manager
Board Deutschland GmbH
Germany
------------------------------
-------------------------------------------0
