View Single Post
  #1  
Old April 20th, 2010, 08:08 PM posted to microsoft.public.word.mailmerge.fields
manatee08
external usenet poster
 
Posts: 5
Default IF . . . THEN . . . ELSE FORMAT DATE

I am trying to compare fields in a database and if NationalFilingDate is
blank, I want the field to show "ApplicationDate" instead. However,
whichever date is chosen for the field, I want the date to format as MMMM dd,
yyyy. The code is shown below. Can someone tell me what I am doing wrong?
Thanks.

{ IF { MERGEFIELD NationalFilingDate} = " " " {MERGEFIELD
NationalFilingDate" } " " {MERGEFIELD "ApplicationDate" /@ "MMMM dd, yyyy"} }