3 Replies Latest reply on Jan 30, 2017 12:00 AM by Dhruv Gupta

    DATEPART - display top of the hour (12:00 vs. 12:0)

    Joshua Preston

      Hello community - This is my first foray into Tableau date functions; so... many...options.

       

      I can't seem to get the DATEPART function below to display the top of the hour with two zeroes. Also, I'd like a12-hour format using the string function. Trying to keep it simple:) Thanks in advance. Tableau 10.x workbook attached.

       

      Function:

      str(datepart('hour',[Date-Start Time]))+":"+str(datepart('minute',[Date-Start Time]))

       

      Screenshot: