Query Data Reader (SET DATE)

Dimas Prayogo
Dimas Prayogo Active Partner
Second Anniversary First Comment
edited April 2020 in Platform
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. 


image
Any solution for this case? or what function i can used for manual query from odbc driver.

Thank you,
Best Regards

Accepted Answer

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    500 Likes Fourth Anniversary 100 Comments 5 Answers
    edited April 2020 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
    ------------------------------
    -------------------------------------------

Categories