View Single Post
  #2   Report Post  
Peter Jamieson
 
Posts: n/a
Default

The comparison operators , and so on do not work with dates - to get
numbers that can be compared in a useful way, try

{ IF{MERGEFIELD Anniversary \@YYYYMMDD } 20042106
"{Mergefield Anniversary \@"MMMM d,yyyy"}" "June 21, 2004"}

Also, please note that there should be spaces around the "", it's
advisable to put quotes round both results (as shown) and all the {} need to
be the special field codes you can insert using cttrl-F9

Peter Jamieson

"Ecofreak" wrote in message
...
I am trying to create a document that brings a date from Access to Word.
Problem is, I want all dates prior to a set date to register as one date
and
all others to register as the date in the database. I created the
following
expression in Word
{IF{MERGEFIELD Anniversary}6/21/2004 {Mergefield Anniversary\@"MMMM
d,yyyy"} "June 21, 2004"}. But the only output I get, regardless of the
Anniversary date is the Anniversary date. Is there a way to write this
expression that will give me the answer I want? (Either in Word or in an
Access Query?) BTW using Office 2000.