Date-Time Issue with Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

debraholloway - 27 Aug 2005 01:18 GMT

In my merge from Excel - my date displays as mm/dd/yy hh:mm:ss
I only want the mm/dd/yy portion. I have tried {MERGEFIELD "Finish_Date"
\@ "mm/dd/yy"} and I still get the other format. What am I missing?

Signature

Debra H.

Reply to this Message

Doug Robbins - 27 Aug 2005 06:29 GMT

Have you tried updating the fields?

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

> In my merge from Excel - my date displays as mm/dd/yy hh:mm:ss
> I only want the mm/dd/yy portion. I have tried {MERGEFIELD "Finish_Date"
> \@ "mm/dd/yy"} and I still get the other format. What am I missing?

Reply to this Message

debraholloway - 28 Aug 2005 19:39 GMT

Yes.

Signature

Debra H.

> Have you tried updating the fields?
>
> > In my merge from Excel - my date displays as mm/dd/yy hh:mm:ss
> > I only want the mm/dd/yy portion. I have tried {MERGEFIELD "Finish_Date"
> > \@ "mm/dd/yy"} and I still get the other format. What am I missing?

Reply to this Message

Doug Robbins - 29 Aug 2005 05:01 GMT

The switch should be \@ "MM/dd/yy". Sorry, I missed that.

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

> Yes.
>
[quoted text clipped - 4 lines]
>> > "Finish_Date"
>> > \@ "mm/dd/yy"} and I still get the other format. What am I missing?

Reply to this Message