Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #110610

Re: Check how date is entered

From GS <gs@v.invalid>
Newsgroups microsoft.public.excel.programming
Subject Re: Check how date is entered
Date 2018-05-05 04:21 -0400
Organization A noiseless patient Spider
Message-ID <pcjpj9$m8e$1@dont-email.me> (permalink)
References (3 earlier) <pci64r$1d5a$1@gioia.aioe.org> <pcijrp$9mi$1@dont-email.me> <pcirib$d6e$1@gioia.aioe.org> <pcj274$u2s$1@dont-email.me> <pcjd0h$147c$1@gioia.aioe.org>

Show all headers | View raw

> On 5/4/2018 8:42 PM, GS wrote:
> ...
>
>> Ambiguities arise when *numeric representation* displays as opposed to 
>> *textual representation* displaying. Auric's code determines whether the 
>> 1st element represents d or m. Isn't this what the OP wants to figure out?
> ...
>
> Yeah, but it depends on what point it is in the process; is it the format of 
> the cell that determines or the data string going into the cell?  I was 
> presuming it was the latter in which case how the cell is formatted is the 
> answer to a question as to how Excel interpreted the string but doesn't 
> _necessarily_ mean that was what the date was from whence it came.

That's not how it works! Dates aren't strings same as currencies arn't strings!

Excel uses the *system* date format by default to display the 'DateSerial' in 
the cell to determine the dmy/mdy of a date based on that system's date format. 
So.., when working with a file created in XP that has date cells, the 
DateSerial is used to determine the datevalue in later OSs. This avoids all 
ambiguity as to the true date being displayed.

The ambiguity for the user arises when the cell format is numeric (05/04/2018) 
if/when the system date format isn't known. Using a textual format eliminates 
the ambiguity because it displays the month name based on the DateSerial of the 
value in the date cell. (What's important to remember here is that what cells 
display isn't necessarily what they contain; -what we see is just how the cells 
are/were formatted to display their contents.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

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