2 Replies Latest reply on Jun 7, 2015 9:07 PM by Suhrid Ghosh

    Facing Error "ERROR 4286: Operator does not exist: timestamp   time HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts"

    Suhrid Ghosh

      Hello,

       

      I have connected to vertica Database with tableau desktop , i have connected to one table which is of daily granularity. That table has

      a column Date which is of Date Type. I have created a calculated field as below with this date column:

       

      IF DATEPART('day',[Date])< [First Day of Month] Then

       

      DATE(DATEADD('day',-(DATEPART('day',[Date])),[Date]))

       

      ELSE DATE(DATEADD('month',1,DATETRUNC('month',[Date])) - 1)

       

      END

       

      Here [First Day of Month] is a integer parameter.

       

      I am getting the below error when i drag this calculated field to Columns Shelf.

       

      ERROR 4286: Operator does not exist: timestamp + time HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts


      Please can anyone help me on this ...


      Thanks,

      Suhrid Ghosh