Project Management

Please login or join to subscribe to this thread

Curious on the date format use in your region YYYY-DD-MM or YYYY-MM-DD or ...

linkedin twitter facebook   Communications Management   Innovation   Knowledge Management   Lessons Learned  
avatar
Vincent Guerard Coach - Trainer - Speaker - Advisor| Freelance Mont-Royal, Quebec, Canada
What is the date format use in your country/region?

MM-DD-YYYY
YYYY-MM-DD
DD-MM-YYYY

Do you see gain in using a for such like YYYY-MM-DD that sort nicely? in any context.

Let me know
Sort By:
< 1 2 >
avatar
Vincent Guerard Coach - Trainer - Speaker - Advisor| Freelance Mont-Royal, Quebec, Canada
Sep 19, 2016 11:44 PM
Replying to Dominic Law
...
Good question, because if you see 02/09/2016, then you are not sure if it means February or September. The norm for American is February, and norm for British is September, but if we are doing global business, then it is confusing.
And I think we never see YYYY-DD-MM.
So YYYY-MM-DD has this additional advantage on top of sorting nicely!
The main gain I have see is sorting.
On the other hand it is getting more precise from year to month to day to hours.....

Thanks
avatar
Vincent Guerard Coach - Trainer - Speaker - Advisor| Freelance Mont-Royal, Quebec, Canada
Sep 20, 2016 2:01 AM
Replying to Rami Kaibni
...
In Canada it depends on the organization. I've seen all 3 formats here.
From Canada also I have seen many with the confusion it sometimes create.
Thanks
avatar
Vincent Guerard Coach - Trainer - Speaker - Advisor| Freelance Mont-Royal, Quebec, Canada
Sep 20, 2016 3:22 AM
Replying to Elizabeth Harrin
...
In the UK it is dd.mm.yy but in my project filing I use yyyymmdd (e.g. "Minutes 20160920.docx") because then it sorts nicely. I picked that tip up while working in France.
Thanks Elisabeth
That is a lot like what I do. Adding to the fact that their is no confusion that I start with Month or day.
avatar
Vincent Guerard Coach - Trainer - Speaker - Advisor| Freelance Mont-Royal, Quebec, Canada
Sep 20, 2016 8:27 AM
Replying to Wade Harshman
...
I prefer 01 Jan 2016 ('dd mmm yyyy').

It makes it unambiguous. No one has to figure out if "4/5/2016" is 5 April or 4 May. It's a good question, though. We can't assume everyone on our team uses the same default date format, especially if you have an international team.

If the dates need to be manually sorted, or if you're naming digital files by date, it's nice to have a number format from small to large (dd.mm.yyyy) or large to small (yyyy.mm.dd). For dates as data, though, you can use Excel to sort any date format, unless you work for a bureaucracy or something similar that requires multiple printed copies in triplicate.
I think it a matter of practice I like elizabeth prefer YYYYMMDD specially in document naming. That place in order directly.
avatar
Walter Pilimon CEO| Web Dev Experts SRL Buenos Aires, Buenos Aires, Argentina
Latin America: dd / mm / yyyy
If you work with organizations in other countries, the most unambiguous method is as outlined above dd - mmm - yyyy (using either dashes, slashed or dots - though in Latin America or the US I have not seen the dot used much - just in Europe)
...
1 reply by Vincent Guerard
Sep 26, 2016 5:55 PM
Vincent Guerard
...
Once Using letter it is unambiguous your right.
Thanks
avatar
Gail Bertrand Project Manager| Air Products Alphen A/D Rijn, Netherlands
For storing files for sorting I find the best format is YYYYMMDD.
For communicating dates, my preference is DDMMMYY, as the month in letters is clearer than a number, and although the letters vary in different languages the English abbreviation is usually well known.
...
1 reply by Vincent Guerard
Sep 26, 2016 5:53 PM
Vincent Guerard
...
Your right when using MMM, it is clear where is the month.
For Storing That is what I do also.
Thanks
avatar
Vincent Guerard Coach - Trainer - Speaker - Advisor| Freelance Mont-Royal, Quebec, Canada
Sep 22, 2016 3:55 AM
Replying to Gail Bertrand
...
For storing files for sorting I find the best format is YYYYMMDD.
For communicating dates, my preference is DDMMMYY, as the month in letters is clearer than a number, and although the letters vary in different languages the English abbreviation is usually well known.
Your right when using MMM, it is clear where is the month.
For Storing That is what I do also.
Thanks
avatar
Vincent Guerard Coach - Trainer - Speaker - Advisor| Freelance Mont-Royal, Quebec, Canada
Sep 22, 2016 12:47 AM
Replying to Walter Pilimon
...
Latin America: dd / mm / yyyy
If you work with organizations in other countries, the most unambiguous method is as outlined above dd - mmm - yyyy (using either dashes, slashed or dots - though in Latin America or the US I have not seen the dot used much - just in Europe)
Once Using letter it is unambiguous your right.
Thanks
avatar
Nicolas Quesada PM I| Citigroup Santiago, Chile
In LatAM= DD/MM/YYYY, however as I work in a global company, I got used to MM/DD/YYYY format
< 1 2 >

Please login or join to reply

Content ID:
ADVERTISEMENTS

"The higher up you go, the more mistakes you are allowed. Right at the top, if you make enough of them, it's considered to be your style."

- Fred Astaire

ADVERTISEMENT

Sponsors