KNOWLEDGE BASE

Hours/seconds details are not displayed even if you choose Exact Date for a date field


Published: 29 Dec 2023
Last Modified Date: 17 Jan 2024

Question

Even though the Exact Date is selected, and after changing the Date Format from Automatic to mm/dd/year, the hours/seconds details are not displayed. Is there a way to display date and time details?

User-added image

Environment

  • Tableau Server
  • Tableau Cloud
  • Tableau Desktop

Answer

Check the date field used and make sure the details such as hours/seconds are not included in the original data/field. If they are not included in the original date/data it will not be displayed in Tableau even if Exact Date is selected. 
User-added image

Use a date format that includes the time information, to displaythe most detailed level of the values when Exact Date is selected.
User-added image

Additional Information

Custom Date Formats
Change Date Levels

Note: Not all date levels are always relevant. For example, if the date format doesn’t include time information such as hour, minute, or second, then these options don't add any data to your view by design.

Did this article resolve the issue?