Posted to microsoft.public.word.mailmerge.fields
|
|
IF then with merged date field from excel
Thank You!
"Graham Mayor" wrote:
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
|