I have moved this from another forum as no-one seems to respond to anything in it...
I have a DTPicker in a userform. When the date is selected, even though it displays in the format ddMMMyy it copies to the document as dd/mm/yyyy.
Why is that and can it be changed?
Also, the date in the calender seems to default to the date it was inserted into the userform, is there any reason why it won't update to the current date when the userform is opened?