3 Replies Latest reply on Jul 12, 2019 6:01 AM by timk

    Combine Date and time

    timk

      Hi All,

       

      I have a 2 different fields (date, time) in the database , Current display for time in the database is 24 h format i.e., 14:35:23

       

      Now I have 2 separate fields in the Tableau.

       

      When I use the below logic I am able to display the date as (1/20/2019 2:44:00 PM) ,

       

      DATEADD('hour', DATEPART('hour', [date_TM]),

      DATEADD('minute', DATEPART('minute', [date_TM]),

      DATEADD('second', DATEPART('second', [date_TM]), [Date])))

       

      but I am looking for the format like 1/20/2019 2:44 PM (I would like to remove the seconds from the time)

       

      Please let me know if anyone has done this.

       

      Thanks