Now certain DATE functions, if given invalid input, return a query failure rather than attempt to fix incorrect logic or return Null. This change ensures data integrity and closer alignment with Data 360 and improves performance. Check existing content to see if you must take action.
Where: This change applies to Tableau Next in Enterprise, Performance, and Unlimited editions.
How: Calculations that use invalid functions can cause query failures. Review existing calculated fields to prevent breaking changes. Make sure that they don’t rely on the "rounding" behavior of the date/time function.
Updated Date Functions
- MAKEDATE
- Previously: Invalid input rounds to the nearest valid date, such as MAKEDATE(2025-03-32) returned 2025-04-01
- Now: Query failure
- MAKETIME
- Previously: Invalid input rounds to the nearest valid time, such as MAKETIME(19, 4, 61) returned 1899-12-30T19:05:01
- Now: Query failure
- DATE and DATETIME
- Previously: Invalid input returns Null
- Now: Query failure