Date Interpreted D/M/YY Instead of M/D/YY

Publish Date: Feb 12, 2025

Description

The DATE() function interprets the string argument as d/m/yy rather than m/d/yy.

To interpret date strings, Tableau Desktop uses the Format setting from the operating system Region and Language settings.

Resolution

In the computer's operating system Region and Language settings, change the Short Date format to M/d/yyyy.

Windows

Go to Control Panel > Clock and Region.
On the Regions menu, make the following selections:
- Under Formats select English (United States).
- Under Short Date, select M/d/yyyy.

As a best practice for converting strings to date values using Date(, pass the string in the ISO 8601 format of YYYY-MM-DD.

For example:
Date("2025-02-15") = February 15, 2025

Additional Resources

In some cases, non-US system locales can experience this issue.

Knowledge Article Number

001473599

Did this article solve your issue?

Let us know so we can improve!