Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mergefield Two Dates One Field
My Excel data source has dates entered in for example 9/15/05 format. In
some cases two dates are entered into the same cell separated by a space. My Word main document has a mergefield for the date with a switch to format the date as September 15, 2005 (MERGEFIELD Date \@ "MMMM d, yyyy"). The mergefield result only shows the second date in the cell in the correct format. The first date is removed. Is there a way to show the two dates in the same field both in the "MMMM d, yyyy" format or must there only be one date per field? I'm using an ODBC connection to the data source. Any help would be greatly appreciated. Thanks. Neal |
#2
|
|||
|
|||
So, basically, your Excel file is using two different formats. If I were
you, I'd format them all as text. ************ Anne Troy www.OfficeArticles.com "PBC" wrote in message ... My Excel data source has dates entered in for example 9/15/05 format. In some cases two dates are entered into the same cell separated by a space. My Word main document has a mergefield for the date with a switch to format the date as September 15, 2005 (MERGEFIELD Date \@ "MMMM d, yyyy"). The mergefield result only shows the second date in the cell in the correct format. The first date is removed. Is there a way to show the two dates in the same field both in the "MMMM d, yyyy" format or must there only be one date per field? I'm using an ODBC connection to the data source. Any help would be greatly appreciated. Thanks. Neal |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank merge fields | Mailmerge | |||
Imbedded MERGEFIELD in IF/ELSE/THEN field | Mailmerge | |||
How do I compare dates in a Word IF field? | Microsoft Word Help | |||
How do I compare dates in a Word IF field? | Microsoft Word Help | |||
How do I compare dates in a Word IF field? | Microsoft Word Help |