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