Forum Discussion
Solved
Datetime2 is not a defined system type
Hello All, I am having some issues with filtering a column by dates when connecting to SQL Server 2005. Whenever I try to filter by dates in the query editor >= 01/01/2015 I get an error: Dat...
We fixed this internally this month. You can expect a fix for this in the March release.
Do you have any control over the database you're connecting to? If so you could look into adding a view on top of the data source and converting the date into text or an integer (or joining to a date dimension) and filtering on that instead.
Unfortunately, no control. Thats a good idea joining it to a date table then I could filter by the values for year and business period.
We fixed this internally this month. You can expect a fix for this in the March release.
tristanstcyr That is awesome! Will make my life a lot easier.
