1 Reply Latest reply on Apr 27, 2013 6:42 AM by Dylan Snyder

    DATEADD or best function to convert a data type from a number data type to a date data type

    Brian Moody

      I am trying to convert a field:  ShipDate from a number type to a date type.  Converting the number to a date after right clicking the field seems to work until Tableau queries the server and gives the error message:

       

      An error occurred while communicating with data source “server”.

       

      Database error 0x80040E57:  ARITHMETIC OVERFLOW ERROR CONVERTING EXPRESSION TO DATA TYPE DATETIME.

       

      I am unsure how to use the DATEADD or if that is the best function, the data in the ShipDate field is formatted ccyymmdd, so 20120224 would be the date February 24th, 2012.

       

      Any help is apreciated.