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