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.

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


--ron