---
schema_version: "1"
id: c0d728ecb19bd49b020cacb9679128c0d27ad11e16e59af3af7d410d0a8d7af3
title: Use New Behaviors in Some Tableau Semantics Functions
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/release-notes/260-0-0/rn_tua_functions.md
canonical_url: https://help.salesforce.com/s/articleView?id=release-notes.rn_tua_functions.htm&release=260&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 41a883d8733ae72114e345a089abfb9776c17665caba8d6dd85f7d5750c7dba3
description: 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.
products:
  - Cross Cloud Packages Solutions
release: "260"
---
# Use New Behaviors in Some Tableau Semantics Functions

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

#### See Also

- [_Salesforce Help_: Calculated Field Formula Functions](https://help.salesforce.com/s/articleView?id=data.c360_a_sl_calc_fields_formula_functions.htm&language=en_US)