Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #110636
| From | dpb <none@none.net> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Check how date is entered |
| Date | 2018-05-07 15:35 -0500 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <pcqdb6$ud$1@gioia.aioe.org> (permalink) |
| References | (18 earlier) <pcoucv$m0c$1@dont-email.me> <pcphq4$f08$1@gioia.aioe.org> <pcq122$8dc$1@dont-email.me> <pcq7c2$1m2m$1@gioia.aioe.org> <pcqccs$1ho$1@dont-email.me> |
On 5/7/2018 3:19 PM, malone wrote: ... > But what amazes me is that we persist in using these two date formats - > d/m/y and m/d/y. It seems absurd we accept conventions that are > blatantly so ambiguous! And, especially, their continuing use by > software engineers who are expected to think logically. I'm always > coming across applications or data where I have to struggle to work out > which is being used. > > d/m/y and m/d/y are not formally internationally accepted date formats > and I'm surprised that there hasn't been a trend towards a more rational > format, such as yyyy-mmm-dd. The very least is a format where the > elements have increasing or decreasing significance - unlike m/d/y which > is neither. No, but we 'Murricuns aren't much given to having others tell us what to do; note the similar reluctance for widespread adoption of metric for common use; after nearly 40 yr since was a widespread attempt to enforce, it's still gotten essentially nowhere outside industrial and scientific circles and I suspect another 40 will be about the same. Date convention in US is a similarly ingrown habit; that there are coding standards is pretty-much immaterial to the casual user and I'd venture 70-80% of the spreadsheets in use are done by just that type of individual; may be pretty adept at the usage of Excel interface and all, but little or no actual coding training so they continue to just use everyday convention. As noted in an earlier response, in a 40-yr+/- consulting career in mostly data acq and instrumentation for power utilities I saw a hundred or more data acq systems put together from probably over half that many vendors and every conceivable form and some that were truly incredible for encoding date and time was in the sample set I think. As noted, even vendors would (and I'm sure still do) provide sample code most probably put together by the summer intern that would think something as sophisticated of deliberately using the sequence order of d/m/y as almost revolutionary and, probably, "European". Teaching those folks about serial numbers is a struggle that one rarely wins. As noted, Matlab has a class |datetime| and has enhanced the C i/o format string to read date strings such that one can on a case-by-case basis handle it on input. MS tends to also be heavy-handed in they code as if everything is MS-consistent and leave it up to the user to conform or write the glue to interact. --
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Check how date is entered jan120253@gmail.com - 2018-05-04 00:31 -0700
Re: Check how date is entered dpb <none@none.net> - 2018-05-04 07:46 -0500
Re: Check how date is entered "Auric__" <not.my.real@email.address> - 2018-05-04 15:55 +0000
Re: Check how date is entered dpb <none@none.net> - 2018-05-04 12:43 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-04 17:37 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-04 18:49 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-04 21:42 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-04 23:46 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 04:21 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-05 07:21 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 09:50 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-05 09:05 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 10:33 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-05 10:57 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 20:51 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-05 11:32 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-05 21:19 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-06 07:46 -0500
Re: Check how date is entered dpb <none@none.net> - 2018-05-06 09:37 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-06 20:37 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-06 19:53 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-06 21:03 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 00:06 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 03:14 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 07:45 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:06 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 13:53 -0500
Re: Check how date is entered malone <malone@nospam.net.nz> - 2018-05-08 08:19 +1200
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 15:35 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 17:38 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 17:26 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 00:19 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 01:31 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 07:45 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 09:45 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 14:34 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 14:09 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 17:06 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 13:48 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 15:02 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 14:59 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 17:04 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 18:53 -0500
Re: Check how date is entered dpb <none@none.net> - 2018-05-08 21:12 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 23:51 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-09 07:20 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-09 11:32 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-09 11:35 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-09 15:03 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-09 15:18 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:34 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 13:44 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 17:40 -0400
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 17:50 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-08 00:02 -0400
Re: Check how date is entered jan120253@gmail.com - 2018-05-07 01:45 -0700
Re: Check how date is entered jan120253@gmail.com - 2018-05-07 01:52 -0700
Re: Check how date is entered dpb <none@none.net> - 2018-05-07 08:16 -0500
Re: Check how date is entered GS <gs@v.invalid> - 2018-05-07 13:10 -0400
Re: Check how date is entered Ramon-México <cesaramon@gmail.com> - 2018-05-07 22:03 -0700
csiph-web