Gallery Who uses what date format?

Who uses what date format?

Any analyst in there career has probably had various date formats waste more time than they care to remember. This is especially true when working for companies or using software that originate from North America, as they use the middle-endian date format (mm/dd/yyyy). I’ll save the debate on which date format is better for another time, but it got me thinking;

“how many people and countries in the world use each date format?”

So I gathered some data together and built the interactive dashboard below, to discover that middle-endian date formatting is only used by 4% of the world’s population and 3% of it’s counties! Just use the drop down to choose which date format you want to see and the dashboard will update automatically.

I hope this dashboard can help you convince your workmates that maybe middle-endian isn’t the way to go, especially if you want to appeal to anywhere else in the world that isn’t North America :)

Let me know if you know a good reason why middle-endian is still being used in the comments below, as I’m super curious as to why. Or if you’ve had any headaches trying to work around it.

Lastly, I couldn’t make a post about date formatting without referencing this XKCD comic.



Please enter your comment!
Please enter your name here


Tableau PublicYouTubeTwitterFacebookLinkedInInstagramEmail Newsletter

Latest Articles

Groceries made easy using Google Sheets

Have you ever wanted to help out more around the house, but not have it take up a lot...

Time Saver Tool v2.0

Have you ever discovered a way to speed up a process but cannot convince others to do it? Felt like you don't...

SG Tableau User Group Oct 2020

The SG Tableau User Group just wrapped up it's October virtual livestream event, which you can now watch on YouTube here. It...

Find insights beyond the summary stats (w/ data viz)

In this video we will see how summary stats can be misleading and the importance of data viz to easily dig deeper into the numbers beneath them.

Data Studio Community Livestream | Jun 2020

Welcome to the first Data Studio Community Livestream - you'll see 4 speakers covering a wide variety of topics, which should help any and...