Why is Alteryx Altering my Date Format?

[Ssmit114]

My data has a few date columns in the format mm/dd/yyyy. It is a very simple workflow, as I am only using a join to add an additional column of data. Alteryx is indiscriminately changing the format of the dates to yyyy-mm-dd. It will be random lines changed to this format. I have tried changing the data type to date, v_String, String, and VW_String. This error still persists. I can't find anything in the forum addressing this question directly. Any help you can provide would be appreciated. Thanks!

[abacon · Accepted solution]

That is alteryx's native date format. When data is a date type field in alteryx, it will be in that format. Use a DateTime tool to convert it to the desired format.

Bacon