AnsweredAssumed Answered

SAP Connector Query Conversion Issue

Question asked by danieledilorenzo on Jul 23, 2019
Latest reply on Aug 29, 2019 by danieledilorenzo

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

Outcomes