Merging date field changes "Day of week"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JNorris - 22 Jun 2004 15:19 GMT

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!

Reply to this Message

Cindy M -WordMVP- - 22 Jun 2004 17:10 GMT

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
[quoted text clipped - 7 lines]
> 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 :-)

Reply to this Message

JNorris - 23 Jun 2004 22:50 GMT

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.

> Hi JNorris,
>
[quoted text clipped - 26 lines]
> This reply is posted in the Newsgroup; please post any follow question
> or reply in the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 24 Jun 2004 10:34 GMT

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.
>
[quoted text clipped - 11 lines]
> 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 :-)

Reply to this Message