Date format switches

[Sara Lindley]

Hopefully someone can solve this problem.

I have used the date switch to swap from US date format to non-US date
format in a word doc and it worked great. When I come to use the same switch
in another word doc it doesn't work. The only thing I have changed is the
field name, and yes, I have typed it in correctly, it was the first thing I
checked! This is the code I've put in

{ MERGEFIELD Date_Received @\ "dd/MM/yy" }

I wondered at first if it had something to do with the space or "_" in the
field name but the field name in the switch that works also has a space.
Basically I am totally stumped!! Can anyone shed any light on this?

 

[Graham Mayor]

The correct syntax is

{ MERGEFIELD Date_Received \@ "dd/MM/yy" }

see http://www.gmayor.com/formatting_word_fields.htm

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Sara Lindley wrote

 

[Sara Lindley]

Hi

Thanks for the reply, silly me typed the syntax in the comment incorrectly,
however, the syntax in the switch is correct and it still won't work!

 

[Graham Mayor]

What do you mean by 'won't work'? Have you updated the field?

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Sara Lindley]

Hi

This is what I have done to try to get it to work

Right clicked and selected update field
Reconnected to the correct query from Access
Merged data to a new document
Repeatedly clicked the "View Merged Data" button
Made sure that the field format in Access is short date
Closed down both Word and Access, opened up Access again and opened the word
file using the access hyperlink

Really starting to question my sanity now!

Cheers

Sara

 

[Doug Robbins - Word MVP]

See the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at :

http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
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

 

[Sara Lindley]

Thanks Doug

After looking around via the link you gave me I found something different to
try and hey presto! after changing the database connection method to "MS
Access Database via ODBC" the date switch works!

Thanks to Graham as well for taking the time to try and solve this for me.