6 Replies Latest reply on Nov 5, 2013 11:54 AM by Eric Horio

    Change date and time format...can't get it working

    Jonathan Richman

      Trying to figure out something, which I thought would be simple.

       

      My data has a date/time stamp formatted like this:

       

      2012-10-29T11:30:12

       

      I tried to use a calculated field to come up with a date format that Tableau understands. Here's what I tried:

       

      DATE(

      MID([timeClosed], 9, 2) //date

      + "-" +

      MID([timeClosed], 6, 2) //month

      + "-" +

      LEFT([timeClosed], 4) //year

      )

       

      However, this doesn't seem to work. The only data that comes from this appears to be either nulls or December 1899. I must be missing something. Any help would be appreciated.

       

      Thanks.

      JMR