Cor said:
I would never advice that especially when I don't know if it has to be 10
januari 2006 or october 1 2006.
The CDate would be the nearest for me as xamman already wrote,
Cor
I would never advice that, as the date format clearly needs to be
specified exactly. Just converting it to a date without an exact format
is not likely to produce a usable result, and the result may even vary
depending on culture settings.
With ParseExact you specify exactly how the date format is supposed to
be interpreted. The OP of course knows if the format is "ddMMyy" or
"MMddyy", otherwise parsing the value is impossible.