3 Replies Latest reply on Nov 28, 2018 2:49 AM by Chris McClellan

    how to extract the Time from the Datetime column?

    Matthew Han


      I have a Datetime column which looks like this " 3/10/2018 6:28:39 AM ".

      I would like to find out how do I use calculated field to create a Time column from this Datetime column.

      The Time column should look like this, " 6:28:39 AM ".

      The discussions on the forum were either very outdated versions of tableau (I'm using 2018.1) or it didn't include the "AM/PM"

      or it only show how to extract the Date part.

      Please kindly point out to me how or if there is a closely related discussion which i may have missed.

      Thank you!