KNOWLEDGE BASE

Error: "Tableau Data Engine Error 48032 : no such function (diffsecond datetime duration)" When Performing a Datediff Calculation


Published: 01 Mar 2017
Last Modified Date: 04 Jul 2017

Issue

When using DATEDIFF calculation between a date time from the data source and a calculated DATETIME() value and dragging it to the view, the following error might occur:

"Tableau Data Engine Error: 48032: no such function (diffsecond datetime duration)"

Environment

  • Tableau Desktop 10.1.4
  • Windows 7
  • Text Files

Resolution

Use the MAKEDATETIME function instead of DATEDIFF.
  • This function is only available with TDEs.
  • Then using this created date field in the DATEDIFF function returns expected results.
  • The MAKEDATETIME function takes a date and a datetime, so use the MAKEDATE and MAKETIME inside. This will take integers for the various date part values. For example: 
MAKEDATETIME( MAKEDATE(1899,12,30), MAKETIME(0,0,0))
Did this article resolve the issue?