Hi,
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?
Solved! Go to Solution.
Hi,
try to replace ' ' with NULL in your SQL statement:
...,Case date_inv_u When '0001-01-01 00:00:00' Then NULL Else date_inv_u End As date_inv_u_test,..
I think ' ' in SQL query will return '0001-01-01 00:00:00' , so it does not replace the wrong entry.
@RolandSchubertthanks for the suggestion, that works!