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.
Brian, try using James's calculation here http://community.tableau.com/message/121095#121095
MID is a string function so you'll either have to convert your integer "date" field to a string in the data window or surround it with STR() in the calculation.