On 5/5/2018 3:21 AM, GS wrote:
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!
....

I'm fully aware of all that...wasn't what I was addressing which is the
date string as the OP wrote it in the query as the only piece of info
available, _NOT_ already stored but want to _be_ stored and wondering
which way is which to do so.

I said specifically the "the data string going _into_ the cell", once
it's _in_ the cell, yes, the cell is formatted as one or the other and
is unequivocal as far as Excel is concerned.

Doesn't _necessarily_ mean it was interpreted correctly when entered,
however, dependent upon the source.

We're talking past each other about different point in the process; ...

I've re-read the OPs ? and _guess_ I now think he probably was meaning
retrieved from a cell and therefore already in Excel so knowing which
way the cell is formatted answers the question.

--