Mailmerge with dates between two values

[Matt]

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]

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


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>