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.
1 Solution
Accepted Solutions
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.
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.
