Merging date field changes "Day of week"

[JNorris]

I haven't been able to find this problem posted. I have a spreadsheet
with dates in the long format (Wednesday, June 9, 2004). Some dates
are entered directly and some are calculated by the WORKDAY function.

When I merge these fields into a word document, sometimes the merged
data changes the day of the week - not the date itself (e.g. Tuesday,
June 9, 2004). It's always off by one day. The data is correct in the
spreadsheet.

I haven't been able to determine a source for this problem and it
doesn't happen for every field.

Any ideas would be greatly appreciated!

 

[Cindy M -WordMVP-]

Hi JNorris,

I haven't been able to find this problem posted. I have a spreadsheet
with dates in the long format (Wednesday, June 9, 2004). Some dates
are entered directly and some are calculated by the WORKDAY function.

When I merge these fields into a word document, sometimes the merged
data changes the day of the week - not the date itself (e.g. Tuesday,
June 9, 2004). It's always off by one day. The data is correct in the
spreadsheet.

I haven't been able to determine a source for this problem and it
doesn't happen for every field.

So... which are changing? The static dates, or the calculated ones?

Which version of Word?

And have you added any formatting switches to the Word fields?

Could you please give us a couple records of sample data, as it appears
in the Excel cell formulas so that we can do some testing?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail

 

[JNorris]

Cindy:

I'm using MS Word 2002.

Here is some spreadsheet data:

Start Date Punch Date Final
Date
(F25)Monday, June 21, 2004 =WORKDAY(F25,11,holidays)
=WORKDAY(F25,14,holidays)

We had the same problem even when Punch Date and Final Date were
entered as dates in long format(not calculated). We had to change the
formatting in excel to text and type in "Wednesday, July 7, 2004" in
order to get the correct information to merge into the Word document.
Unfortunately, we need these dates to be calculated because they can
change often. Any help is appreciated.

Thanks in advance.

 

[Cindy M -WordMVP-]

Hi JNorris,

OK, by default word 2002 uses an OLE DB connection. And it turns out
that this doesn't work very well with either Access or Excel;
especially not with Excel.

So the first thing I'd try would be a different way to connect to the
data. If you activate "Confirm conversions on open" in
Tools/Options/General, after you select the xls file you should get a
list of methods. Try each of those; does any give you a useable result?

I'm using MS Word 2002.

Here is some spreadsheet data:

Start Date Punch Date Final
Date
(F25)Monday, June 21, 2004 =WORKDAY(F25,11,holidays)
=WORKDAY(F25,14,holidays)

We had the same problem even when Punch Date and Final Date were
entered as dates in long format(not calculated). We had to change the
formatting in excel to text and type in "Wednesday, July 7, 2004" in
order to get the correct information to merge into the Word document.
Unfortunately, we need these dates to be calculated because they can
change often.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail