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 / June 2006

Tip: Looking for answers? Try searching our database.

Superscripted date

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lupe - 30 Jun 2006 15:13 GMT
Hi,
I have checked the posts to see if I could find a solution for my problem
and found an answer and link to the site of Graham Mayor. I have tried to use
the format he suggested for superscripted date but it constantly gives me an
error. Is there something wrong with my field codes? My data source is in
Excel and is formatted d mmmm yyyy.
{QUOTE{MERGEFIELD Date \\@ “dddd ‘the’ d”}{IF{=(mod({MERGEFIELD Date\@
d},10)<4)*(mod({MERGEFIELD Date\@ d},10)<>0)*({MERGEFIELD Date\@ d}<>11*({
MERGEFIELD Date\@ d}<>12)*({ MERGEFIELD Date\@ d}<>13)}=1{=mod({MERGEFIELD
Date\@ d},10)-2 \#  rd;st;nd } th}{ MERGEFIELD Date\@ “’of’ MMMM, yyyy"}}
Graham Mayor - 30 Jun 2006 15:29 GMT
Rather than attempt to reproduce this code manually, which invites errors
(there's one in the first field - I didn't check any farther) download the
document that contains the field code from the link at
http://www.gmayor.com/insert_a_date_other_than_today.htm. Paste the fields
into your document and edit the DATE fields it contains to match the
mergefield in your data source.
Turn off the autoformat that changes straight quotes to smart quotes!
If you can't work it out from that - contact me via the link on my web site
home page, giving details of the date field name in your Excel data file -
and what you want to do with it.
Signature

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

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

> Hi,
> I have checked the posts to see if I could find a solution for my
[quoted text clipped - 7 lines]
> d}<>13)}=1{=mod({MERGEFIELD Date\@ d},10)-2 \#  rd;st;nd } th}{
> MERGEFIELD Date\@ "'of' MMMM, yyyy"}}
Lupe - 30 Jun 2006 16:40 GMT
Graham, I downloaded the zip file of Macropod on your page "Formatting Word
fields with switches" and I got my answer. Thanks!
Lupe

> Rather than attempt to reproduce this code manually, which invites errors
> (there's one in the first field - I didn't check any farther) download the
[quoted text clipped - 17 lines]
> > d}<>13)}=1{=mod({MERGEFIELD Date\@ d},10)-2 \#  rd;st;nd } th}{
> > MERGEFIELD Date\@ "'of' MMMM, yyyy"}}

Rate this thread:






 
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.