| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF then with merged date field from excel
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  |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
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 |
|
#3
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 |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
IF then with merged date field from excel
You are welcome.
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Holly wrote: 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 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail Merge document and Date field | Mailmerge | |||
| How to correct too much decimals and date if merged from Excel? | Mailmerge | |||
| Turn off "automatically update" date field after merged? | Mailmerge | |||
| How to prevent Merged Date Field showing time? | Mailmerge | |||
| Date issue merging from Excel field in Date format to Word | Mailmerge | |||
Linear Mode
