🌐
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…
🌐
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.
Discussions

European date format not recognized by Sheets - 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 28, 2019
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
May 24, 2012
Change date format to European format: date/month/year
I am needing to change the date format in MS Project to the following: European date format which is date month year or DD/MM/YYYY. I do not see this option in the drop down when I go to File/Options. Any assistance? More on learn.microsoft.com
🌐 learn.microsoft.com
1
27
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
3 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."
🌐
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.
🌐
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).
Find elsewhere
🌐
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
🌐
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...
🌐
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 ...
🌐
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.
🌐
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......
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.

🌐
Dutch to English
dutchtrans.co.uk › home › differences in translation for dates usa europe
Differences in Translation for Dates USA Europe | DutchTrans
September 1, 2024 - In this blog post, we’ll go into more detail about the differences between American and European translations of dates, as well as why it’s important to be aware of them in case you need a correction of translation error. When filing for a patent in the United States, it is important to understand the American date format and how it differs from the European format.
🌐
Microsoft Office Forums
office-forums.com › archive › newsgroup archive › excel newsgroups › excel general
Converting european date format to US format. | Microsoft Office Forums
August 5, 2013 - I get a report from europe with date format 13-01-2012 00:00:00 . I tried simply formmating it to US format, but it only applies it to the first 12 days of each month. All help is greatly appreciated.
🌐
My Date Note
mydatenote.com › collections › eu-date-format-date-notes › eu-date
EU Date Format Date Notes
In the context of MyDateNote.com, a European Date Note would feature the DDMMYYYY format in its serial number. By example July 4, 1776 would be 04071776.
🌐
Smartfuel
smartfuel.es › portada › página de ejemplo › ways to write a western european date
Ways to Write a Western european Date - Smartfuel - Reposta más rápido y barato
August 2, 2023 - If you are posting a date in European style, it will appear like this: “2022 January 5. ” This data format is used by many countries in Europe, including the United Kingdom.
🌐
Peppol
docs.peppol.eu › poacc › billing › 3.0 › syntax › ubl-invoice
Peppol BIS Billing 3.0 - November 2025 Release
Specification identifier An identification of the specification containing the total set of rules regarding semantic content, cardinalities and business rules to which the data contained in the instance document conforms · Default value: urn:cen.eu:en16931:2017#compliant#urn:fdc:peppol.eu...
🌐
Copernicus
cds.climate.copernicus.eu › datasets › reanalysis-era5-single-levels
ERA5 hourly data on single levels from 1940 to present
June 14, 2018 - ERA5 is the fifth generation ECMWF reanalysis for the global climate and weather for the past 8 decades. Data is available from 1940 onwards. ERA5 replaces the ERA-Interim reanalysis. Reanalysis combines model data with observations from across the world into a globally complete and consistent ...