user11351 Member

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

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 '='

Thanks, Chris. Unfortunately, call_date is a date/time field and will not compare to Curdate.

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