user11351 Member

• Activity
• Discussions1
• Comments4

Comments

• I am running a mySql data flow and getting the same error. I have run it multiple times.

  in "Invalid query, DataSet schema needs to be updated" Error message Comment by user11351 May 2020
• Thanks. Unfortunately, that gave me an error The database reported a syntax error. Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '='

  in how do you format date for comparison to today Comment by user11351 June 2019
• Thanks, Chris. Unfortunately, call_date is a date/time field and will not compare to Curdate.

  in how do you format date for comparison to today Comment by user11351 June 2019
• so then you think this would work case when date_format(`call_date`,%y %m %d)=CURDATE() then 'Today' when date_format(`call_date`,%y %m %d)=CURDATE()-1 then'Yesterday' end but it doesn't

  in how do you format date for comparison to today Comment by user11351 June 2019