Loading

Error "Schema/DataTable mismatch" When Using DATEADD()

Udgivelsesdato: Feb 24, 2026
Beskrivelse
When creating a calculation using DATEADD(), that has division in the interval argument, the calculation is valid.  However, when the calculation is added to the view Tableau Desktop returns the following error:
 
Unable to complete action ColumnTable:
Schema/DataTable mismatch" error when the calculation is added to the view

Cause

The DATEADD() function requires an integer for the interval argument. Division will convert a number to decimal number, also known as a float.
Løsning
Wrap the formula in the interval argument in INT().
SUGGESTION: Add parentheses around the interval argument in INT().

For example, an original equation may look like this:
SUGGESTION: For example, an original calculation may look like this: 
DATEADD('day', [Parameter]/2, [Date Field] )

And then may become this after wrapping the formula in the interval argument in INT():
SUGGESTION: And then, after encapsulating the interval argument in INT(), will look like this: 
DATEADD('day', INT( [Parameter]/2 ), [Date Field] )
Yderligere ressourcer
Some live data sources may not experience this issue, for example Microsoft SQL Server, as those data sources are more flexible with data types.

Vidensartikelnummer

001471238

 
Indlæser
Salesforce Help | Article