IF then with merged date field from excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Holly - 13 Jan 2006 06:27 GMT

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 :)

Reply to this Message

Graham Mayor - 13 Jan 2006 08:09 GMT

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.

Signature

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

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

> I would like to use an IF statement for a merged field but cannot
> seem to get it right.
[quoted text clipped - 4 lines]
>
> Help - I dont have much hair left :)

Reply to this Message

Holly - 14 Jan 2006 00:49 GMT

Thank You!

> See http://www.gmayor.com/formatting_word_fields.htm
>
[quoted text clipped - 11 lines]
> >
> > Help - I dont have much hair left :)

Reply to this Message

Graham Mayor - 14 Jan 2006 07:05 GMT

You are welcome.

Signature

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

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

> Thank You!
>
[quoted text clipped - 21 lines]
>>>
>>> Help - I dont have much hair left :)

Reply to this Message

Rate this thread: