Yes, it was unfortunate that all the examples from the OP could be
interpreted either way. If his second example had been 11251999 or
25111999, then we'd all have known what language we were speaking.

I suppose that the fact he said he wanted his output formatted as mm/dd/yy
or mm/dd/yyyy format should have been a hint to me if I'd been wider awake.
It's an interesting reminder that these things need to be clearly specified,
and often need the Windows Regional Options set accordingly. As it was,
your formula and the one from Gary's Student gave totally different answers
on my machine.
--
David Biddulph

"Ron Rosenfeld" wrote in message
...

Probably because I'm in the US and not UK, David, I took it that the OP's
data
format was mddyyyy or mmddyyyy.

You need to look at his SECOND example: 11051999

On Thu, 8 Feb 2007 13:46:25 -0000, "David Biddulph"

wrote:

Doesn't that screw up with single digit months, Ron? Try it on the OP's
first example, 3042006, or his 3rd example, 1012001.