SAP Connector Query Conversion Issue

Daniele Di Lorenzo
Daniele Di Lorenzo Customer
Fourth Anniversary 250 Up Votes 100 Likes 100 Comments
in Platform

Hi Community

 

moving from SAP Connector version 2.30 to 3.3.11 a WHERE clause has not been properly coverted

 

There is a query that have to import data up to today only and the syntax was

 

PROMISE_DATEM1 < '#{ Datetime.Now.ToString("yyyyMMdd") }#'

 

converting the query the date becames fixed

 

PROMISE_DATEM1 < '20190628' 

 

If I restore manually the previous syntax the query does not work, and the error is "Unknown identifier 'Datetime'."

 

can someone help?

thanks

Answers

  • Daniele Di Lorenzo
    Daniele Di Lorenzo Customer
    Fourth Anniversary 250 Up Votes 100 Likes 100 Comments

    solved.

     

    Don't know why, but copying the syntax from theobald website it works

  • Daniele Di Lorenzo
    Daniele Di Lorenzo Customer
    Fourth Anniversary 250 Up Votes 100 Likes 100 Comments

    Hello all

     

    I just discovered that the problem appears when I run the query from SAP connector (run in browser).

    If, after that, I click on “OK” instead of “Cancel”, the script get lost.

     

    BEFORE      sap_DATE < '#{ DateTime.Now.ToString("yyyyMMdd") }#'

    AFTER       sap_DATE < '20180829'

     

    Does anyone had same problem?

Categories