UK Date bug in Word XP - Anyone know a fix?

[JethroUK©]

I have a mail merge connected to a a database & M.S word (XP) displays
'some' dates in U.S. date format (m/d/y) instead of UK (d/m/y) - obviously i
cant use these for professional mail-shots as i'd intended

No formatting can cure this and apparently it's a bug - this is a company
machine and the chances of an upgrade will be at best next year

meanwhile - anyone know any fix/work around for this - i'm not above a vba
fix if ness

 

[Suzanne S. Barnhill]

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

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[JethroUK©]

as i mentioned - Word 2002 can't format UK dates - it's a documented bug -
i'm actually looking for a fix to this, so i can use it professionally

anyone know anything about this? - and maybe a fix

 

[Suzanne S. Barnhill]

If you apply a formatting switch, the date will be displayed as you desired;
see http://word.mvps.org/FAQs/TblsFldsFms/DateFields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[JethroUK©]

it wont i'm afraid - it's a documented bug with Word XP 2002 (suprised you
dont know about it) - there's a fix for this in sp3 but i dont anticipate an
upgrade for a year

 

[Doug Robbins - Word MVP]

If you are using Access as the datasource, I would create a query that made
use of the format() function the force the date into the desired format.

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

 

[Cindy M -WordMVP-]

Hi JethroUK©,

as i mentioned - Word 2002 can't format UK dates - it's a documented bug -
i'm actually looking for a fix to this, so i can use it professionally

anyone know anything about this? - and maybe a fix

Did you actually read through the information on Graham's site? Or read his
last reply to you? Most of the information as to workarounds is there (as in
use a DDE or ODBC connection). You'll also find information (in a denser
format) on my site, in the Word 2002/2003 section.

A fix was issued in one of the more recent Service Packs (SP), probably SP2.
It's also fixed in Word 2003. And by "fix" I mean that the day/month
information doesn't get switched around "by whim", but is passed across
consistently.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail

 

[JethroUK©]

I dont think the query formatting is an option for me because i imagine this
would affect the input format on the form (appointment date & time)

Graham Mayor suggested connecting as DDE via connection options - and this
seems to have fix it

good news is that Word connected this way automatically even after taking
the tick out