>>>>Try with the newer driver. If I remember correctly, the newest driver works with DATE type, but has problems with varchar(max). The oldest driver works with varchar(max) but doesn't work with DATE type.
>>>
>>>Where can i find that driver?
>>
>>This is what I have for SQL Server drivers. I have SQL Server 2014 installed locally.
>>Check which drivers do you have (run odbcad32.exe from Windows/SysWow64 directory.
>
>Updated to 11.0 still no joy
>
>What version do you have for the "SQL Server" driver? i can't see in the pic you sent

Try Antonio's code.

I have version 2011.110.6518

But I didn't check if it correctly works with date. We're not using DATE type, only datetime. We do use varchar(max), so we're using older driver.