Milliseconds transferred from DATEPARSE are not recognized when connecting to Hyper files

Published: 16 Nov 2023
Last Modified Date: 17 Nov 2023


Milliseconds transferred from the DATEPARSE function as shown below is not recognized correctly when connecting to Hyper files:

User-added image


  • Tableau Desktop 2023.2


Adjust the DATEPARSE calculation and use a custom format.  To view the solution listed below, see the sample packaged workbook found in the Attachments section of this article.

1. Change the DATEPARSE calculation to use ".SSSSSS" as demonstrated below:

User-added image

2. Now change the Format to be a Custom Format and include millisecond by performing the following:

Right-click on the formatted field in the view and select Format.

User-added image

Set the format as shown below, using "000000" to display milliseconds:

User-added image

User-added image

Did this article resolve the issue?