SAP Connector Query Conversion Issue

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

Find more posts tagged with

solved.

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

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?