5 Replies Latest reply on Nov 2, 2017 2:03 PM by Harry Vanderburg

    SQL Server - DATETIME errors when filter by Relative Date

    Michael Muller

      I’ve created a dashboard, and I’m having an issue with the filters.

       

      The basics – I’m pulling data from the sql server.  The Date field is pulled in the format 20,170,531 (for 5/31/2017).  I’m able to convert the number to the date of 5/31/2017. 

       

      On this converted date field, when I try to pull a relative date (the last 3 months) I receive this error:

       

      [Microsoft][ODBC SQL Server Driver][SQL Server]Explicit conversion from data type date to timestamp is not allowed.

      [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.

       

      I’ve tried creating a calculated field that turns it into DATETIME format…but receive this error:

       

      [Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation

       

      Help!