View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default IF . . . THEN . . . ELSE FORMAT DATE

And you need the switch on both mergefields. Also a blank field is probably
"" not " "

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"dshaulis" wrote in message
...
I believe you / should be the other way \ . It should be \@ "MMMM d,
yyyy"

Hope that helps.

"manatee08" wrote:

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"} }