>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 +.

Thanks again.