[thomb@bossoft.com]

Ok I can see what is happening. Formatting dates where the datatype is string is tricky (and as you saw also dependant on the PC).
For example

rd = "101214"

Debug.Print Format(rd, "mm/dd/yyyy")

This is the result: 02/09/2177
If you are capturing input from a user, it's likely they could use different date formats. A generic formatter to convert them all will be a challange.

I'd be inclined to use a VBA userform with a Microsoft Date and Time Picker control. Here's an example:
/site/Customers/Boston-Workstation/Script-Center/Utilities/USer-Forms/Date-Selection-Dialog