Date field of SQL Server being Converted to String automatically

[NiloyJyoti]

I am loading my data in SQL Server table with datatype as Date.

While reading this data in Alteryx , getting automatically converted to V_Wstring. Could anyone help me understand why would this happen.

We have lot of tables and many corresponding Date columns in the process. Typecasting all of these columns might not be a feasible solution for us.

I am checking the datatype in this tool shown below:

[DavidSkaife · Accepted solution]

Hi @NiloyJyoti 

Interesting that it's correctly identifying the DateTime fields, but not the date fields. There are a few solutions i could find on the community that point to it being an issue with the drivers used (see https://community.alteryx.com/t5/Alteryx-Designer-Discussions/In-Database-datatype-change/td-p/56361 for example) but these are for the in-DB tool, what type of driver/connection you're using could be an avenue to explore though?

in the meantime what happens if you place an autofield tool just after the extract, does that change the field type to Date?

[NiloyJyoti]

@DavidSkaife  This was helpful. Applying auto field resolved the issue for now.