July 14, 2014 at 7:58 pm
#4896
thomb@bossoft.comModerator
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.
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