Convert text to date

[theDBguy]

Hi, yes i did, however, the "text" that holds the date is 211130 , yymmdd, by using CDate(Format([TextField], "00-00-00")) , i cannot convince the system which two digits relate to yy. I don't want to change my whole system settings as this might affect other sections, anyway, by using the string functions, i twisted the text and now it is just fine.

Hi. Thanks for the additional information. What did you expect the result to be? This is what I got.

If you're saying you got a different result because you have a different Regional Settings, then I guess that would make sense. Cheers!