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:




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



      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.