View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor
 
Posts: n/a
Default IF then with merged date field from excel

See http://www.gmayor.com/formatting_word_fields.htm

{IF {Mergefield Date_of_Hire \@ "yyyyMMdd"} 20050101 "01/01/2005"
"{Mergefield Date_Of_Hire \@ "MM/dd/yyyy"}"}

Change the last mask if you are not using a US date pattern.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Holly wrote:
I would like to use an IF statement for a merged field but cannot
seem to get it right.

I would like to say
IF DATE_OF_HIRE is 1/1/05 then 01/01/2005 else use the data thats
in the DATE_OF_HIRE field

Help - I dont have much hair left