Date showing as Varchar – SQLServer

Hello Helical Insight,

I am using Helical Insight 4.0 with my SQL Server. I have noticed that the datetime column is shown as text or varchar. Due to this, I am not able to get filter conditions like “greater than”, “less than”, “between” etc. Why is there a mismatch? I have crosschecked at the dblevel it is specified correctly at the DBlevel.


Hello Jam,

On the datasources page of Helical Insight 4.0, there are 2 icons that you will see for SQLServer. One has a green tick (driver present) and one with no driver present.


The driver that is present for SQLServer by default is generic and may not be fully compatible with some versions of SQL Server.
It is advised that you use the sqljdbc4 driver by clicking on “Download Relevant database driver” and then uploading it.


Once you create metadata from this new downloaded DBdriver you will see that it will be able to identify all the relevant datatypes correctly.

Helical Insight.