Issue
When using DATEDIFF in a calculated field, a message similar to the following may appear:DATEDIFF is being called with (string, date, date, integer). Did you mean (string, datetime, datetime, string)?
Last Modified Date: 20 Sep 2023
Environment
Tableau DesktopResolution
Ensure the correct field types are in use.For example, the following calculation will not work:
DATEDIFF('month',[Order Date],[Ship Date],1)
Instead, the calculation should be written as follows:
DATEDIFF('month',[Order Date],[Ship Date],'sunday')
Cause
Although DATEDIFF may be used with dates instead of datetimes, the start_of_week field must be a string and not an integer.Additional Information
Date FunctionsThank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials