Query Data Reader (SET DATE)

Dimas Prayogo

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

Björn Reuber

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
------------------------------
-------------------------------------------