I've got a date picker control on a userform in my Word 2010 VBA macro.
I simply want to extract value of the user chosen date as a string in short date format, e.g. "1/24/2015" so I can stick it into a document. The date picker is showing a valid date (say, today).
If I use Me.MyDatePicker.value, I always get 12:00:00 AM
If I try to first assign the value to a date variable, I get some bizarre date in 1941.
dim mydate as date
mydate = Me.MyDatePicker.value
What am I missing?