Date on server coming in as a string

[icoleman]

Backstory: I have a exchange rate table that consists of a Date column set as a date field and and the exchange rate column set as float. These have been part of a workflow for 6 months or so and nothing has been a problem.

Problem: All of a sudden Alteryx will only recognize it as a date field when I first attach it. As soon as I hit f5 it switches it over to a string.

The table on the left is what it turns into and the one on the right is me just adding it again in the visual query builder.

Any clue on what is going on here?

[randreag]

hello @icoleman 

 Is it possible the data comes with any symbol not commonly used on dates or letters?

[icoleman]

it's all 2020-01-01 type format from what I see.