KNOWLEDGE BASE

Error "No such function that takes arguments of type (date, date)" Connecting to Teradata


Published: 27 Nov 2017
Last Modified Date: 27 Nov 2017

Issue

When joining another data source to Teradata, the following error occurs: 
No such function that takes arguments of type (date, date)

Environment

  • Tableau Desktop
  • Teradata

Resolution

Option 1:

Replace any calculations of the form TODAY() - [Date] with  DATEDIFF('day',[Date],TODAY())

Option 2: 

Change the date field used in a TODAY() - [Date] calculation to a datetime data type. 
 

Cause

Calculations of the form TODAY()- [Date] are not allowed by Teradata. 
Did this article resolve the issue?