On 5/7/2018 12:34 PM, GS wrote:
There still is no way to determine which of two ambiguous date forms
from another system _AS THE TEXT DATE STRING_ is which from the string
format alone; and it still isn't totally clear for OP's problem after
the explanation whether he has the required information at the point
he's trying to solve the problem or not.

The OP's Q:
*"Is there anyway to *check with VBA* if a date is entered as DD-MM-YY or
* MM-DD-YY? How can I tell *using VBA* if 4-5-18 is actually 4th of May of
* Fifth of April?"

Auric's reply answers this accurately!

That's true and acknowledged. What we don't know is whether the correct
answer to the question asked is the answer to the underlying problem or
not; insufficient data to tell.

What the answer is is what Excel thinks the data are and how will be
exported; what we don't know is whether that is the same as what the
foreign system thinks they are for the two cases--my gut feeling is
"there be dragons!" but don't know for sure.

--

On 5/7/2018 12:34 PM, GS wrote:
There still is no way to determine which of two ambiguous date forms from
another system _AS THE TEXT DATE STRING_ is which from the string format
alone; and it still isn't totally clear for OP's problem after the
explanation whether he has the required information at the point he's
trying to solve the problem or not.

The OP's Q:
*"Is there anyway to *check with VBA* if a date is entered as DD-MM-YY or
* MM-DD-YY? How can I tell *using VBA* if 4-5-18 is actually 4th of May of
* Fifth of April?"

Auric's reply answers this accurately!

That's true and acknowledged. What we don't know is whether the correct
answer to the question asked is the answer to the underlying problem or not;
insufficient data to tell.

What the answer is is what Excel thinks the data are and how will be
exported; what we don't know is whether that is the same as what the foreign
system thinks they are for the two cases--my gut feeling is "there be
dragons!" but don't know for sure.

Agreed!

--
Garry

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

On 5/7/2018 4:40 PM, GS wrote:
....

What the answer is is what Excel thinks the data are and how will be
exported; what we don't know is whether that is the same as what the
foreign system thinks they are for the two cases--my gut feeling is
"there be dragons!" but don't know for sure.

Agreed!

Ah! We finally(!) got to the point was trying to make... :)

There's "knowing" and then there's "knowing"...and the two aren't always
necessarily the same.

--

On 5/7/2018 4:40 PM, GS wrote:
...

What the answer is is what Excel thinks the data are and how will be
exported; what we don't know is whether that is the same as what the
foreign system thinks they are for the two cases--my gut feeling is "there
be dragons!" but don't know for sure.

Agreed!

Ah! We finally(!) got to the point was trying to make... :)

There's "knowing" and then there's "knowing"...and the two aren't always
necessarily the same.

Very true:)

--
Garry

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