Output 1900-01-01 to CSV

[PeterAP]

Does anyone know why when I output the date of 1900-01-01 to CSV, it's converting to 1900-01-02?

[Emil_Kos]

Hi @PeterAP,

please explore difrent data types. For exemple If you export the data as date Please change it to string. 

hopefully it helps

[DannyS]

@PeterAP 

Can you share your workflow/output so we can troubleshoot why that is happening? I tested this with a text input tool and output data tool to csv and did not see any issues:

[PeterAP]

@DannyS Apologies, I've checked my workflow and it's outputting to .xlsx not csv and that's where the problem is happening