Loading

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

Udgivelsesdato: Feb 12, 2025
Beskrivelse

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

Cause

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

Løsning

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

Windows

  1. Go to Control Panel > Clock and Region.
  2. 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

Yderligere ressourcer

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



Vidensartikelnummer

001473599

 
Indlæser
Salesforce Help | Article