KNOWLEDGE BASE

Datediff Results are Returning Incorrect Values with a Live Connection to Oracle


Published: 11 Oct 2016
Last Modified Date: 07 Jul 2017

Issue

Datediff results are returning incorrect values with a live connection to Oracle (or MS SQL Server) in Tableau Desktop 9.3.

Environment

  • Tableau Desktop 9.3.6
  • Oracle
  • MS SQL Server

Cause

This behavior is related to a known defect (ID: 573390) that has been fixed in recent releases of Tableau Desktop.

Additional Information

  • Datediff results differ between a live connection in TD 9.2 and TD 9.3.
  • Datediff results differ between a live connection and extract in TD 9.3.
  • Datediff results should match for all of the following: Live connection in TD 9.2, extract in TD 9.2, extract in TD 9.3
Did this article resolve the issue?