>>One way is to build a string with the unambiguous date format {^yyyy-mm-dd} and then EVALUATE() it:

* Following assumes century is 19:
>>* An unambiguous date will work with single-digit month and year e.g. {^1982-6-1}
>>DateValue = EVALUATE("{^" + "19" + RIGHT(mDOB, 2) + "-" + LEFT(mDOB, LEN(mDOB) - 3) + "-" + "1" + "}")

>
>Hi Al - thankyou for your response. This worked. I was even able to check the century by seeing if the year was greater than 99, which would then be the 2000 +.

Henry, you are definitely the candidate for the champion title for this year, and the category would be described as "Converting data from weird text formats". You seem to have luck to work with the weirdest. My sympathies.