This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow with an SQL query as an input that returns about 50,000 records.
The results have 2 'Conv Errors' as below - I would like to modify the query so that values like this are automatically replaced with blanks/nulls (I know these errors are nothing to worry about but someone else may not).
I have tried replacing 'date_inv_u' in the SQL statement with the below:
...,Case date_inv_u When '0001-01-01 00:00:00' Then '' Else date_inv_u End As date_inv_u_test,...
The workflow runs without any errors, but the results are odd. See below. What am I doing wrong?