Loading

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

Дата публикации: Feb 24, 2026
Описание
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.
Решение
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] )
Дополнительные ресурсы
Some live data sources may not experience this issue, for example Microsoft SQL Server, as those data sources are more flexible with data types.

Номер статьи базы знаний

001471238

 
Загрузка
Salesforce Help | Article