Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
cjshaffer cjshaffer is offline
external usenet poster
 
Posts: 5
Default Date and Day issue in Mailmerge

I am wondering if anyone has seen the day of the week change from an excel
data source in a mailmerge. I have an event date column in which i had the
date of the event ie October 3, 2009 in it. I formatted the column in Excel
to display the day...Saturday, October 3, 2009. When I choose the data
source for the mail merge it bumps the day up by one day and displays Sunday,
October 3, 2009. Does anyone know why this happens and how I can resolve it?
Thanks
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Date and Day issue in Mailmerge

Hi cjshaffer,

Are you sure the date stored in Excel isn't actually 3 October 1909 (a Sunday) displayed as 3/10/09 or something such?

--
Cheers
macropod
[Microsoft MVP - Word]


"cjshaffer" wrote in message ...
I am wondering if anyone has seen the day of the week change from an excel
data source in a mailmerge. I have an event date column in which i had the
date of the event ie October 3, 2009 in it. I formatted the column in Excel
to display the day...Saturday, October 3, 2009. When I choose the data
source for the mail merge it bumps the day up by one day and displays Sunday,
October 3, 2009. Does anyone know why this happens and how I can resolve it?
Thanks

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
cjshaffer cjshaffer is offline
external usenet poster
 
Posts: 5
Default Date and Day issue in Mailmerge

Great thought but i don't think it is the culprit. It must have something to
do with settings or version of the software since I tested it on a different
user at work and had the same thing happen but when I went and tested at home
it came over correct. Still curious to know why though

"macropod" wrote:

Hi cjshaffer,

Are you sure the date stored in Excel isn't actually 3 October 1909 (a Sunday) displayed as 3/10/09 or something such?

--
Cheers
macropod
[Microsoft MVP - Word]


"cjshaffer" wrote in message ...
I am wondering if anyone has seen the day of the week change from an excel
data source in a mailmerge. I have an event date column in which i had the
date of the event ie October 3, 2009 in it. I formatted the column in Excel
to display the day...Saturday, October 3, 2009. When I choose the data
source for the mail merge it bumps the day up by one day and displays Sunday,
October 3, 2009. Does anyone know why this happens and how I can resolve it?
Thanks


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge issue Manish[_2_] Mailmerge 4 July 9th 08 10:19 AM
date mailmerge problem Bob Bedford Mailmerge 5 March 17th 06 09:57 AM
Date-Time Issue with Merge debraholloway Mailmerge 3 August 29th 05 05:01 AM
Issue with Data Sourde in Mailmerge ryankeast Mailmerge 3 January 29th 05 01:44 AM
Date issue merging from Excel field in Date format to Word Barb Reinhardt Mailmerge 1 December 17th 04 08:34 AM


All times are GMT +1. The time now is 05:07 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"