Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

Why is Alteryx Altering my Date Format?

Ssmit114
5 - Atom
‎05-23-2025 08:45 AM

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!

Labels:
Reply
0 Likes
1 REPLY 1
abacon
12 - Quasar
‎05-23-2025 10:19 AM

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.

Baconimage.png

Reply
0 Likes
Christmas in July Blog
designer new user guide