If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|