Automation Logging:09/22/2009 2:08:31 PM: Variable “Date_Rels” set to “#CompleteOrders.Date_Rels#”
Automation Logging:09/22/2009 2:08:31 PM: Variable value = Syntax error
Is this a known bug? Workaround?
In my automation script, I am setting variables, running a query on an Oracle db, then looping thru the query results to deliver output data to an email. The char() data resolves OK, but when I use date data I get strange results.
produces a numeric value based on the sum: (-dd -yyyy). Changing to ‘DD-MON-YYYY’ gives similar results.
See attachment for example.
If I use just the database attribute CREATION_DATE without converting to char, I get an error: