Alteryx recognizes dates in one input file but not the other

Question

Hello

I built a workflow to format my data for one of my reports. In my input file I have a column for dates dd-Mon-yy, as seen in the first screen shot, which Alteryx is converting to dd-Mon-yyyy format, as seen in second screenshot. But when I used last years data to test the workflow Alteryx didn't convert the dates, as seen in third and fourth screenshot. This is causing the workflow to fail because I am joining on this field.

Any ideas as to why it is changing some dates but not others?

Prometheus · Answer

@Travis_Ratliff Interestingly enough, there's no difference between the two fields. In this workflow I created with your dataset, you can see in the Select tools that Alteryx recognizes each field immediately as a Date data type, so you wouldn't get the different outputs that you're getting above.

Dates.yxzp

Travis_Ratliff · Answer

@Prometheus See attached for the two date fields.

Date Field Test Data.xlsx

Prometheus · Answer

@Travis_Ratliff I meant in the workflow. If you would upload just the date fields in these two datasets, I would be able to provide a more practical solution. My guess is that although the dates appear a certain way in Excel, it doesn't mean that they're actually formatted that way. For instance, if you type 2023-10-26 into Excel, it'll convert it to 10/26/2023.