DTPicker

[runningpiema]

hi there,

this is very annoying that there are so many date time pickers in word VBA. I am using DTPicker 6.0 but i need it to display the date as Saturday, 22nd March 2013.

Wondering if you could please help.
Thanks,

Gordon

[Doug Robbins]

While you can define a CustomFormat in the Properties dialog for the DTPicker control and set the Format to 3-dtpCustom, to make use of the date in such a format in some other place (in the document for example) you will have to use the Format function such as

Format(Me.DTPicker1, "dddd, dd MMMM yyyy")

It takes a bit more to get the ordinal (st, nd, rd, th) if you really need it.