>>>One way is to build a string with the unambiguous date format {^yyyy-mm-dd} and then EVALUATE() it:
>>>* 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.
Dragan - I could not stop laughing as yet - and I like the title - but with so many gurus around I have no fear of facing the most evil types of text formats :)
- Ravi
True greatness consists in being great in little things.
- Charles Simmons