4 Replies Latest reply on Aug 29, 2018 12:59 PM by Jackie Meija

    Pulling Hours/Minutes Into One Column with Data Type of Datetime

    Jackie Meija

      I am accessing a SQL database that gives me a Datetime field.  I can break it down in Tableau by Year, Quarter, Month, Day, Hour etc.

       

      I know you can format this data to display as MM/DD/YY by choosing the custom option on either the Year, Month etc. dimensions.

       

      But why is there no option to view the Hours and Minutes in their on custom display such as HH:MM?  I really don't want to leave them in separate columns.  Thanks for the help!