Merge field formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 05 Aug 2005 17:47 GMT

Using MS Word 2000, I need to format a 6-digit merge field as a date.
I try: { MERGEFIELD Date1 \@ M/d/yy } where Date1 is the field name, but I
only get the six digits e.g. 102004 showing in my letter. What am I missing?

Reply to this Message

Peter Jamieson - 05 Aug 2005 18:53 GMT

I think Word thinks your 102004 is a number.

Assuming it means 20th October 2004, as a first shot, try the following,
where each pair of {} are the special field braces you can insert using
ctrl-F9:

{ QUOTE { MERGEFIELD Date1 \#"00/00/00" } \@M/D/Y }

Make sure the M, D and Y are uppercase.

Peter Jamieson

> Using MS Word 2000, I need to format a 6-digit merge field as a date.
> I try: { MERGEFIELD Date1 \@ M/d/yy } where Date1 is the field name, but I
> only get the six digits e.g. 102004 showing in my letter. What am I
> missing?

Reply to this Message

Jim - 05 Aug 2005 22:05 GMT

Peter, thanks for the suggestion. However, I get an error: "Too many picture
switches defined." My date is coming in via a .CSV file. I don't know how I
could tell Word that the value is a date and not just a 6-digit number.

> I think Word thinks your 102004 is a number.
>
[quoted text clipped - 12 lines]
> > only get the six digits e.g. 102004 showing in my letter. What am I
> > missing?

Reply to this Message

Peter Jamieson - 05 Aug 2005 23:55 GMT

Are you sure all the {} are field code braces? It seems to work OK here.

Try { MERGEFIELD Date1 \#"00/00/00" }

first, then create a new field

{ QUOTE "" \@M/D/Y }

and copy/paste the mergefield inside the quotes.

Peter Jamieson

> Peter, thanks for the suggestion. However, I get an error: "Too many
> picture
[quoted text clipped - 19 lines]
>> > only get the six digits e.g. 102004 showing in my letter. What am I
>> > missing?

Reply to this Message