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!



        1 2 Previous Next