SET DateFormat='YYYY-MM-DD'; doesn’t recognize SQL Server dates

[wdchristensen]

When I run the script below, Qlik Sense is treating the incoming dates as though they were text. I even attempted to use “CONVERT(varchar, getdate(), 23)” to ensure the data was coming in as a VARCHAR(10) in the 'YYYY-MM-DD' format and the values are still showing up at strings. I am using SQL Server 2016 and my connection is using the SQLOLEDB driver. 

The odd thing is that I have no issues with the TimeStampFormat. 

[wdchristensen · Accepted solution]

Hey Buddy, 

I had the same issue and the root cause was the OLE DB driver. Try changing your connection to the "Microsoft SQL Server" driver.