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

wdchristensen — Sat, 16 Nov 2024 21:37:07 GMT

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.

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

wdchristensen — Thu, 10 Jan 2019 22:22:56 GMT

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.

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

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

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