Of course using CDate() on a string value is rather unsafe.

A "date" string like "01-06-2002" may just as easily convert to June 1st as Jan 6th depending on your current UI settings for date formats.

Don't do this. You are building bugs into your code and bad habits into your brain.