Word 2002 form letter date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonny - 25 Apr 2004 14:16 GMT

I am using Word 2002 and the database in MS Works 7.0. Have produced the form letter and inserted place holders from the database. The problem is that all dates inserted into the form letter have the format month/day/year regardless of the date format in the database and in regional settings being day/month/year. The database also offers an option of day/month which is the format I want to use in all my form letters. I have used this format with Works 4.5 successfully for many years
I would appreciate any help

Reply to this Message

Graham Mayor - 25 Apr 2004 14:28 GMT

There are a couple of issues here. One is that in order to merge a Works
database, you have to have installed the horrendously buggy Works add-in for
Word, so you are likely to suffer spurious problems - one of the most
obvious being the propensity for adding dozens of mail merge entries to the
tools menu in Word.

The immediate problem however is easily resolved, using a mergefield switch
in Word - see http://www.gmayor.com/formatting_word_fields.htm

In this instance a switch of \@ "d/MM/yyyy" should do the trick.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> I am using Word 2002 and the database in MS Works 7.0. Have produced
> the form letter and inserted place holders from the database. The
[quoted text clipped - 4 lines]
> all my form letters. I have used this format with Works 4.5
> successfully for many years. I would appreciate any help

Reply to this Message