Loading

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

Дата публикации: Feb 12, 2025
Описание

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.

Решение

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

Дополнительные ресурсы

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



Номер статьи базы знаний

001473599

 
Загрузка
Salesforce Help | Article