Environment Details
When connecting to SQL Server to pull data into the Input Data tool or In-DB tool, "date" datatype fields are changed to "V_WString"
- Alteryx Designer
- OleDB Driver
Table Structure example:
OleDB Connection:
Medatadata:
Cause
You are using driver 'Microsoft OLE DB Provider for SQL Server'
Resolution
Redo the connection and select provider 'SQL Server Native Client 11'
OleDB Connection:
Medatadata:
null