Forum Discussion
0000/00/00 Date format error
I found how to fix the error.
First convert the Text form column into a Date Format. You'll see the error pop up. Now in Query Editor, go in the "Transform" ribbon and look for "Replace Value", click on the small down arrow besides it and choose "Replace Error". A small windown will pop out and you can input the value to replace the error. The value that will replace the error has to be the same Type as the values in that column.
Hi NaCl-y,
You also can replace it in the first place. Please refer to the following snapshot.
Best Regards,
Dale
I found how to fix the error.
First convert the Text form column into a Date Format. You'll see the error pop up. Now in Query Editor, go in the "Transform" ribbon and look for "Replace Value", click on the small down arrow besides it and choose "Replace Error". A small windown will pop out and you can input the value to replace the error. The value that will replace the error has to be the same Type as the values in that column.
Hi NaCl-y,
You also can replace it in the first place. Please refer to the following snapshot.
Best Regards,
Dale