>>>>>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.

LOL that's the old one for you?? I see installed version 6.01.7601.17514 ! How can i update that?