1 2 Previous Next 18 Replies Latest reply on Nov 7, 2013 12:03 PM by Jonathan Drummey

    Formatting dates with calculations

    Matthew McLaughlin

      Afternoon, all!

       

      My ERP system uses dates in the CYYMMDD format.  Tableau doesn't like this format.   I'm trying to make this a little more useful and am running into troubles.  I create a calculated field on Due Date, for example:

       

      Due Date = (20000000+([ODDTMY]%1000000)

       

      While Tableau recognizes this as an integer, it doesn't recognize this as a date.   How do I change this field to be a date?  I ultimately need this in my chart as a filter.

       

      Thanks in advance!

       

      Matt

        1 2 Previous Next