Help with Date/Time picker

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jille - 05 Oct 2006 14:49 GMT

I have a userform that includes a Date/Time picker control.

I have assigned a variable to the output but when I insert the variable
contents into a Word document (into a text formfield formatted as plain
text), it is returning the time instead of the date (always 12:00:00).

I don't think the problem lies in the Word doc...I have tested the code and
somewhere it switches to time instead of date. The variable is declared as a
date.

Any thoughts?

Reply to this Message

Doug Robbins - Word MVP - 05 Oct 2006 19:55 GMT

Use the Format() function to get the format that you want.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a userform that includes a Date/Time picker control.
>
[quoted text clipped - 9 lines]
>
> Any thoughts?

Reply to this Message