IF then with merged date field from excel

[Holly]

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

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Holly]

Thank You!

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Graham Mayor]

You are welcome.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>