Project Management

Project Management Central

Please login or join to subscribe to this thread

Topics: Communications Management, Innovation, Knowledge Management, Lessons Learned
Curious on the date format use in your region YYYY-DD-MM or YYYY-MM-DD or ...
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 >
Network:4639
@Work - MM/DD/YYYY
@ All other places - DD/MM/YYYY

Sorting can be done using any date format.
...
1 reply by Vincent Guerard
Sep 21, 2016 9:18 PM
Vincent Guerard
...
Your right most software would sort correctly.

But that is not true of the browser in most computer, also most word processing are not efficient on that.

Thanks
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!
...
1 reply by Vincent Guerard
Sep 21, 2016 9:21 PM
Vincent Guerard
...
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
In Canada it depends on the organization. I've seen all 3 formats here.
...
1 reply by Vincent Guerard
Sep 21, 2016 9:22 PM
Vincent Guerard
...
From Canada also I have seen many with the confusion it sometimes create.
Thanks
in germany it is

dd.mm.yyyy
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.
...
1 reply by Vincent Guerard
Sep 21, 2016 9:24 PM
Vincent Guerard
...
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.
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.
...
2 replies by Rami Kaibni and Vincent Guerard
Sep 20, 2016 1:59 PM
Rami Kaibni
...
I prefer the same Wade: Day / Month / Year
Sep 21, 2016 9:26 PM
Vincent Guerard
...
I think it a matter of practice I like elizabeth prefer YYYYMMDD specially in document naming. That place in order directly.
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 prefer the same Wade: Day / Month / Year
This has been very enlightening for me. I think I definitely prefer 'dd mmm yyyy' format. It IS less confusing. I have seen several formats in the U.S.
Without talking about points, slash or others,

In Europe I've worked with DD.MM.YYYY

Now, in USA sometimes I have to think twice before write, because here always MM.DD.YYYY

In a global companies we've used the format of the country where they have the headquarters. With clear communication we've avoided misunderstandings.
Sep 19, 2016 11:29 PM
Replying to Anupam
...
@Work - MM/DD/YYYY
@ All other places - DD/MM/YYYY

Sorting can be done using any date format.
Your right most software would sort correctly.

But that is not true of the browser in most computer, also most word processing are not efficient on that.

Thanks
< 1 2 >

Please login or join to reply

Content ID:
ADVERTISEMENTS

There are two ways of spreading light: to be the candle or the mirror that reflects it.

- Edith Wharton

ADVERTISEMENT

Sponsors