conventions for date representation around the world
The legal and cultural expectations for date and time representation vary between countries, and it is important to be aware of the forms of all-numeric calendar dates used in a particular country … Wikipedia
🌐
Wikipedia
en.wikipedia.org › wiki › List_of_date_formats_by_country
List of date formats by country - Wikipedia
4 days ago - For instance, depending on the order style, the abbreviated date "01/11/06" can be interpreted as "1 November 2006" for DMY, "January 11, 2006" for MDY, or "2001 November 6" for YMD. The ISO 8601 format YYYY-MM-DD (2026-03-10) is intended to harmonise these formats and ensure accuracy in all ...
🌐
Wikipedia
en.wikipedia.org › wiki › Date_and_time_notation_in_Europe
Date and time notation in Europe - Wikipedia
June 15, 2025 - As a European Norm, CEN and CENELEC member states are obligated to adopt the standard as national standard without alterations as well. Except for Austria, Germany and Switzerland, see the navigation box on the bottom to find individual articles per country. Official EU documents still tend to use DD.MM.YYYY but one document specifies the use of ISO 8601: "Dates should be formatted by the following format: YYYY-MM-DD."
Discussions

When Americans don’t understand European date format on an imported German product
Why do Americans do basically everything backwards compared to the rest of the world? Dates, weight, volume, temperature, distance, paper sizes, English spelling, 12 hour clocks, area, force, etc. It’s like a bizarro land. More on reddit.com
🌐 r/USdefaultism
160
605
December 30, 2023
Date & Time Format mostly used in EU - Feature Requests - n8n Community
The idea is: Official EU documents still tend to use DD.MM.YYYY but one document specifies the use of ISO 8601: "Dates should be formatted by the following format: YYYY-MM-DD. date format in europe At this moment most … More on community.n8n.io
🌐 community.n8n.io
0
September 14, 2022
american english - Date format in UK vs US - English Language & Usage Stack Exchange
Why is the most common date format in the US like mm/dd/yyyy, whereas in Europe (including the UK) it's more common to have dd/mm/yyyy? Looking around, I found that the US form is actually the more traditional Anglo-Saxon way, but the British adapted to using the European form in the early ... More on english.stackexchange.com
🌐 english.stackexchange.com
Change date for European use DD/mm/yy - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
🌐 support.google.com
April 25, 2023
🌐
data.europa.eu
data.europa.eu › apps › data-visualisation-guide › date-formatting
Date formatting - data.europa.eu
ISO 8601 is the international standard for formatting dates and time. For dates, this format is YYYY-MM-DD, for example 2022-02-24. This notation has some advantages over other formats. For example, alphabetical sorting of dates in this format is equal to chronologically sorting the dates.
🌐
Reddit
reddit.com › r/usdefaultism › when americans don’t understand european date format on an imported german product
r/USdefaultism on Reddit: When Americans don’t understand European date format on an imported German product
December 30, 2023 - ISO 8601 is too broad. For the dates alone (because with time and timezones it gets worse) it allows for too many formats, today is 2023-12-31 but also 2023-W52-7, 2023-365 and 2023W527 whereas for RFC 3339 only the first format is valid.
🌐
Not One Off Britishisms
notoneoffbritishisms.com › 2012 › 04 › 09 › european-date-format
European date format
April 9, 2012 - In the United Kingdom and, in fact, most of the rest of the world, today's date would be indicated 9 April 2012 or 9/4/12. In the U.S., it would be April 9 (or 9th), 2012, or 4/9/12. We tend to think (as in most things) that we are doing it the "normal" way, but, Europe…
🌐
W3C
w3.org › International › questions › qa-date-format
Date formats
July 4, 2007 - Visitors to a web site from varying locales may be confused by date formats. The format MM/DD/YY is unique to the United States (but sometimes used in Canada, too, which can obviously create some confusion there). Most of Europe uses DD/MM/YY. Japan uses YY/MM/DD.
🌐
Quora
quora.com › What-is-the-European-style-for-writing-dates
What is the European style for writing dates? - Quora
Answer (1 of 2): The same as the ... number as 2 digits or name as 1st 3 letters) and year (in 2 or 4 digit format). dd/mm/yyyy or dd-mm-yyyy dd/mmm/yyyy or dd-mmm-yyyy For some s......
Find elsewhere
🌐
Worlddata
worlddata.info › homepage › timezones › date and time formats
Date and time: International formatting
The 12-hour system is mainly used in English-speaking countries, the USA, Australia and the English-speaking parts of Canada. Great Britain itself is excluded from this and uses the 24-hour format that is common in Europe. For a European, "12:30" is clearly lunchtime, while 00:30 means a time shortly after midnight.
🌐
n8n
community.n8n.io › feature requests
Date & Time Format mostly used in EU - Feature Requests - n8n Community
September 14, 2022 - The idea is: Official EU documents still tend to use DD.MM.YYYY but one document specifies the use of ISO 8601: "Dates should be formatted by the following format: YYYY-MM-DD. date format in europe At this moment most of our EU data is under ...
🌐
Oreate AI
oreateai.com › blog › understanding-the-differences-european-date-format-vs-us-date-format › f81d7212ffd0f02b255b42c718f57b0f
Understanding the Differences: European Date Format vs. US Date Format - Oreate AI Blog
January 15, 2026 - The crux of the matter lies in how dates are structured. In Europe, many countries follow the day-month-year format (DD/MM/YYYY), while in contrast, the United States adheres to month-day-year (MM/DD/YYYY).
Top answer
1 of 4
18

Although there are people who will sometimes say:

  1. Today is Thursday, the 24th of May, 2012.

There are also others who instead say the same thing this way:

  1. Today is Thursday, May 24th, 2012.

Certainly in the United States, the second way of mentioning a date is more common than the first. The long form sounds more formal to us, as in “on the Fourth of July” being more formal and long-winded than simply saying “on July 4th”.

It was pronouncing the month before the day out loud that gave to retaining that same original order when converted to digits: merely convert the month name to a natural number, and there you have your answer. What’s today’s date? It’s May 24th. Instead of writing May-24, we simply change the “May” to “5” and write 5-24 or ⁵⁄₂₄.

That way it follows the natural language order and so requires no mental gymnastics to switch things around when speaking the date aloud. Similarly “September 11th” gets written ⁹⁄₁₁, etc.

The full spoken form with the year, “May 24th, 2012”, then becomes the written shorthand “5/24/2012”, or often just “5/24/12”. “Christmas of 2001” can be, and somewhat annoying often is, written “12/25/1”, while “January 25th, 2012” becomes “1/25/12”.

This isn’t usually any sort of problem because of universal consensus on how to interpret such things in the United States. If you write day/month/year in America, you will not be understood. Although I myself prefer the ISO notation, normal people do not use it in their daily affairs.

2 of 4
4

It's very possible that the US inherited this from an outdated English format - much like the length unit, after Henry III's foot and which the English have left behind in favour of the more logical metric system.

One argument I've heard in favour of the American system of dating is that the numbers of months in a year is smaller than the number of days in a month which itself is smaller than the number of possible years. So you would have 12/31/2013, in ascending order. I don't really buy this argument, but OP might be interested in it anyway so here it is.

Meanwhile, in Northern Europe they've moved on to an opposite, descending date standard: year/month/day.

🌐
YourDictionary
yourdictionary.com › reading & writing › spelling › how to write the date properly in different ways
How to Write the Date Properly in Different Ways
December 8, 2017 - So January 4, 2005 would simply have the month and day switched around, making it 4 January 2005. Notice in a formal European version of the date, there's no comma. The comma separating the date from the year is an Americanism that the Europeans do not follow. Here are some of the regions that format their date in the Day/Month/Year format:
🌐
Google Support
support.google.com › docs › thread › 212676562 › change-date-for-european-use-dd-mm-yy
Change date for European use DD/mm/yy - Google Docs Editors Community
April 25, 2023 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
🌐
Microsoft Community
techcommunity.microsoft.com › microsoft community hub › communities › products › microsoft 365 › excel
Conversion from European Date Format | Microsoft Community Hub
June 23, 2020 - I'm using Excel 365. I just copied a column of dates from a web page and pasted them into a column in Excel. The dates on the web page were in the European date format (i.e., dd/mm/yyyy).
🌐
Google Support
support.google.com › docs › thread › 5074322 › european-date-format-not-recognized-by-sheets
European date format not recognized by Sheets - Google Docs Editors Community
April 28, 2019 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
🌐
Rick Steves Travel Forum
community.ricksteves.com › travel-forum › general-europe › form-of-dates
Form of dates. - Rick Steves Travel Forum
October 26, 2019 - Europe operates on the dd/mm/yyyy way of expressing dates. In Europe, 9/11 is the ninth of November. Dates on this forum are expressed as mm/dd/yyyy, even though the forum is all about Europe. There are posters on this forum from outside the USA. I don’t get it.
🌐
Quora
quora.com › In-the-continental-European-date-format-DDMMYYYY-there-is-a-logical-sequence-moving-from-to-smallest-time-unit-of-the-three-to-the-bigger-ones-Whats-the-logic-behind-the-MMDDYY-format-used-in-the-US
In the continental European date format (DDMMYYYY) there is a logical sequence, moving from to smallest time unit of the three to the bigger ones. What's the logic behind the MMDDYY format, used in the US? - Quora
Answer (1 of 6): In the continental European date format (DDMMYYYY) there is a logical sequence, moving from to smallest time unit of the three to the bigger ones. What's the logic behind the MMDDYY format, used in the US? The ISO system (YYYY/MM/DD) moves from year to month to day, which starts...
🌐
Statology
statology.org › home › excel: convert date format from european to u.s.
Excel: Convert Date Format from European to U.S.
August 16, 2023 - Europe uses a standard date format of dd/mm/yyyy while the U.S. uses a standard date format of mm/dd/yyyy. You can easily convert a European date format to a U.S.