2 Replies Latest reply on Jun 20, 2016 2:11 PM by Dan Cory

    Automated DATEPART function causing error

    Steven Eysenbrandts

      Hi,

       

      When adding a date to my columns bar it automatically creates a DATEPART() function for year. I like it but it is creating a SQL error: "Syntax Error in the SQL statement.[10104]"

       

      I know it is a generic issue, but I was hoping others ran into this issue before and can help me? I tried avoiding this and adding the necessary date conversions into the custom SQL script but I had similar errors.

       

      My source is Netsuide using the ODBC driver.

       

      Steven