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 ???