3 Replies Latest reply on Dec 12, 2014 3:49 PM by Steve Mayer

    date compare error

    amardeep singh

      hi, I am trying to create a report using Teradata connection in tableau. I have a field called "activity date" that has a date format.

      when I try to use this formula in my calculated field

      if [Activity Dt] == DATE( "3/31/2014" ) then [Activity Dt] end

      I get the following error

      [teradata][odbc teradata driver][teradata database] A character string failed conversion to a numeric value.[teradata][odbc teradata driver][teradata database] A character string failed conversion to a numeric value.

       

      please advice.