Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

CSV - Error parsing date value

PassION_es
10 - Fireball

Hello Alteryx,

 

Can you please me with the error encountered when uploading the csv output in the Oracle.

I am getting this error: Error parsing date value: ?12/07/2023

 

I already converted 12-07-2023 date to a string with format 12/07/2023 as this is the format displayed in the usual csv we uploaded in the web, and also tried the datetimeformat using formula tool we have however, date parsing error still occured.  The csv output cannot be uploaded due to this error.

 

 

Hope you can help me if you have the same case for csv output to be uploaded in oracle/controllersweb.

 

Thank you.

 

 

 

 

 

 

2 REPLIES 2
cjaneczko
13 - Pulsar

Can you sure a screenshot of what the date looks like at the end of your workflow and the data type of the field? It sounds like you make it look like a date, but the data type of the field is not correct.

PassION_es
10 - Fireball

Hello Cjaneczko,

 

This is already solved. 

 

I have just unchecked the "Write BOM" in the output file of csv format.

 

Thank you.

Labels