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

    Combine Date and time


      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.