11 Replies Latest reply on Nov 29, 2018 10:22 PM by Jasneet Kaur

    calculate hours from timestamp

    Jasneet Kaur

      Hey,

       

      I am having one field <Timestamp> contains 11/17/2018  6:02:24 AM this format now I wanted to calculate how many hours from today's date and show in table text.

      I tried DATEDIFF function not able to get the accurate data... Using Tableau Desktop version

       

      Example:

      DateCurrent Datetimeresult
      11/29/2018 16:0011/29/2018 16:30
      30 mint ago
      11/29/2018 13:0011/29/2018 16:303 hour ago

          

      Please guide me on it am new in this..

       

      Thanks in advance..