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?