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 / January 2004

Tip: Looking for answers? Try searching our database.

Mailmerge with dates between two values

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Matt - 29 Jan 2004 00:07 GMT
In the Microsoft Knowledge Base Article - 214214, it says that it is not
possible to do a Less Than or Greater Than compare on dates as Word
interprets the dates as text.  eg the following would not work :-

{IF {MERGEFIELD mydate \@ "M/d/yy"} > "4/15/97" "true" "false" }

So can anyone suggest to me how I COULD manage it?  I have a mailmerge who's
data holds passport information.  When the merge is run, it's supposed to
check the date of travel and compare it to the passport expiry date.  If the
expiry date is before the end of the holiday, the merge needs tp print a
warning that they should renew their passport before flying eg :-

{if {MERGEFIELD PassportExpiryDate \@ dd/mm/yyyy} < #26/04/2004# "Please
renew your passport" ""}

How can I achieve this ???
Graham Mayor - 29 Jan 2004 06:55 GMT
The KB article is wrong if that's what it says - see the
Testing for events that occur before or after a certain date

section of http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP
      E-mail gmayor@mvps.org
     Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> In the Microsoft Knowledge Base Article - 214214, it says that it is
> not possible to do a Less Than or Greater Than compare on dates as
[quoted text clipped - 13 lines]
>
> How can I achieve this ???
 
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.