Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2008

Tip: Looking for answers? Try searching our database.

Date Format Frustration - inconsistency

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jimbob - 15 May 2008 09:14 GMT
There are many postings over date format and I thought I'd got the measure of
it having referred to Graham Mayor's excellent site.  Until . . .
I have a letter which populates with 3 dates from a client contact
spreadsheet.  They were all formatting beautifully then bizarrely, after a
recent change elsewhere in the Word document, 2 format OK and 1 gives the
numerical value and I get, for instance: 23rd and 39715th.  The field codes
are exactly the same, i.e. { MERGEFIELD "aDate1" \@ "d" \*Ordinal} and {
MERGEFIELD "aDate2" \@ "d" \*Ordinal}.
The 3rd date is elsewhere in the document and that's still fine. I've tried
replacing the mergefield and using it elsewhere in the document but that
gives the same result.

Any advice would be gratefully reecived.  Many Thanks

I'm using Word 2003
Doug Robbins - Word MVP - 15 May 2008 09:56 GMT
Are the cells both formatted the same way in Excel?

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

> There are many postings over date format and I thought I'd got the measure
> of
[quoted text clipped - 14 lines]
>
> I'm using Word 2003
Jimbob - 15 May 2008 10:20 GMT
Yes, all 3 are formatted exactly the same.

> Are the cells both formatted the same way in Excel?
>
[quoted text clipped - 16 lines]
> >
> > I'm using Word 2003
Graham Mayor - 15 May 2008 10:39 GMT
What do {Mergefield aDate1} and {Mergefield aDate2} produce?

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Yes, all 3 are formatted exactly the same.
>
[quoted text clipped - 26 lines]
>>>
>>> I'm using Word 2003
Jimbob - 15 May 2008 11:45 GMT
Well, you're not going to believe this but after spending an age on this
yesterday and this morning, I've opened it again and the Excel spreadsheet to
answer your question.  I now find that all dates are exactly as I wanted and
expected them to be.
I'll surely be back with an answer to your question if the issue recurs.

Many thanks for your trouble.

> What do {Mergefield aDate1} and {Mergefield aDate2} produce?
>
[quoted text clipped - 28 lines]
> >>>
> >>> I'm using Word 2003
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.