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 |
#11
|
|||
|
|||
Is there a Special method to inserting fields?
Sort of - it works but still bugging out:
XL Source = Sat 20 Oct 11:00 AM { MERGEFIELD CSCS_Test_DateTime \@ "ddd dd MMM hh:mm am/pm" } = Thu 20 Oct 12:00 AM ????????? { MERGEFIELD CSCS_Test_DateTime } = Sat 20 Oct 11:00 AM It looks like the date/time format is failing - sent out all my appointments wrong today - but it's fine now without the formatting? "macropod" wrote in message ... Hi Graham, Sorted in the mailmerge field forum. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Graham Mayor" wrote in message ... JethroUK© wrote: The source is e.g. Thu 18 Oct 06:00 PM {Mergefield "CSCS_Test_DateTime" } (after DDE connection) is same: Thu 18 Oct 06:00 PM What does the field produce with the default connection - ie what is the underlying data in the source? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#12
|
|||
|
|||
Is there a Special method to inserting fields?
You get that because when WOrd sees the text string "Sat 20 Oct 11:00 AM"
and tries to extract a date from it, what it sees is 20 Oct 11, i.e. 20 Oct 2011, i.e. Thu 20 Oct at 12:00 AM. To get it to recognise the text correctly you would have to insert the year - then I think Word would get the day right and recognise the time correctly as well, probably. Peter Jamieson "JethroUK©" wrote in message ... Sort of - it works but still bugging out: XL Source = Sat 20 Oct 11:00 AM { MERGEFIELD CSCS_Test_DateTime \@ "ddd dd MMM hh:mm am/pm" } = Thu 20 Oct 12:00 AM ????????? { MERGEFIELD CSCS_Test_DateTime } = Sat 20 Oct 11:00 AM It looks like the date/time format is failing - sent out all my appointments wrong today - but it's fine now without the formatting? "macropod" wrote in message ... Hi Graham, Sorted in the mailmerge field forum. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Graham Mayor" wrote in message ... JethroUK© wrote: The source is e.g. Thu 18 Oct 06:00 PM {Mergefield "CSCS_Test_DateTime" } (after DDE connection) is same: Thu 18 Oct 06:00 PM What does the field produce with the default connection - ie what is the underlying data in the source? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#13
|
|||
|
|||
Is there a Special method to inserting fields?
Hi Jethro,
Is this an actual date & time in Excel, or just a string? If it's an actual date & time, what *year* is in the Excel data? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "JethroUK©" wrote in message ... Sort of - it works but still bugging out: XL Source = Sat 20 Oct 11:00 AM { MERGEFIELD CSCS_Test_DateTime \@ "ddd dd MMM hh:mm am/pm" } = Thu 20 Oct 12:00 AM ????????? { MERGEFIELD CSCS_Test_DateTime } = Sat 20 Oct 11:00 AM It looks like the date/time format is failing - sent out all my appointments wrong today - but it's fine now without the formatting? "macropod" wrote in message ... Hi Graham, Sorted in the mailmerge field forum. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Graham Mayor" wrote in message ... JethroUK© wrote: The source is e.g. Thu 18 Oct 06:00 PM {Mergefield "CSCS_Test_DateTime" } (after DDE connection) is same: Thu 18 Oct 06:00 PM What does the field produce with the default connection - ie what is the underlying data in the source? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#14
|
|||
|
|||
Is there a Special method to inserting fields?
Hi
It works fine without the formatting - it currently shows full date/time if the appoinment is pending: Sat 20 Oct 11:00 AM And short date once it has passed (becomes history) 20-Oct which is perfect for me - but just for interest - It is a proper date/time field formatted in XL as: ddd dd mmm hh:mm AM/PM (not text) i often leave out the year in the format but for sure it is 2007 - i don't know, but if it is being translated as text it's just guessing and it's guessing wrong "macropod" wrote in message ... Hi Jethro, Is this an actual date & time in Excel, or just a string? If it's an actual date & time, what *year* is in the Excel data? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "JethroUK©" wrote in message ... Sort of - it works but still bugging out: XL Source = Sat 20 Oct 11:00 AM { MERGEFIELD CSCS_Test_DateTime \@ "ddd dd MMM hh:mm am/pm" } = Thu 20 Oct 12:00 AM ????????? { MERGEFIELD CSCS_Test_DateTime } = Sat 20 Oct 11:00 AM It looks like the date/time format is failing - sent out all my appointments wrong today - but it's fine now without the formatting? "macropod" wrote in message ... Hi Graham, Sorted in the mailmerge field forum. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Graham Mayor" wrote in message ... JethroUK© wrote: The source is e.g. Thu 18 Oct 06:00 PM {Mergefield "CSCS_Test_DateTime" } (after DDE connection) is same: Thu 18 Oct 06:00 PM What does the field produce with the default connection - ie what is the underlying data in the source? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#15
|
|||
|
|||
Is there a Special method to inserting fields?
I'm sure you're right - it's a shame date/times can't be passed as numbers
which aren't open to mis-interpretation "Peter Jamieson" wrote in message ... You get that because when WOrd sees the text string "Sat 20 Oct 11:00 AM" and tries to extract a date from it, what it sees is 20 Oct 11, i.e. 20 Oct 2011, i.e. Thu 20 Oct at 12:00 AM. To get it to recognise the text correctly you would have to insert the year - then I think Word would get the day right and recognise the time correctly as well, probably. Peter Jamieson "JethroUK©" wrote in message ... Sort of - it works but still bugging out: XL Source = Sat 20 Oct 11:00 AM { MERGEFIELD CSCS_Test_DateTime \@ "ddd dd MMM hh:mm am/pm" } = Thu 20 Oct 12:00 AM ????????? { MERGEFIELD CSCS_Test_DateTime } = Sat 20 Oct 11:00 AM It looks like the date/time format is failing - sent out all my appointments wrong today - but it's fine now without the formatting? "macropod" wrote in message ... Hi Graham, Sorted in the mailmerge field forum. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Graham Mayor" wrote in message ... JethroUK© wrote: The source is e.g. Thu 18 Oct 06:00 PM {Mergefield "CSCS_Test_DateTime" } (after DDE connection) is same: Thu 18 Oct 06:00 PM What does the field produce with the default connection - ie what is the underlying data in the source? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#16
|
|||
|
|||
Is there a Special method to inserting fields?
Hi Jethro,
In that case, the problem is likely due to the fact you aren't displaying the year in Excel. Without that, Word is coercing the hour into duty as the year number - 20 Oct 2011 is a Thursday. You'll need to make sure the (correct) year is displayed in Excel. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "JethroUK©" wrote in message ... Hi It works fine without the formatting - it currently shows full date/time if the appoinment is pending: Sat 20 Oct 11:00 AM And short date once it has passed (becomes history) 20-Oct which is perfect for me - but just for interest - It is a proper date/time field formatted in XL as: ddd dd mmm hh:mm AM/PM (not text) i often leave out the year in the format but for sure it is 2007 - i don't know, but if it is being translated as text it's just guessing and it's guessing wrong "macropod" wrote in message ... Hi Jethro, Is this an actual date & time in Excel, or just a string? If it's an actual date & time, what *year* is in the Excel data? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "JethroUK©" wrote in message ... Sort of - it works but still bugging out: XL Source = Sat 20 Oct 11:00 AM { MERGEFIELD CSCS_Test_DateTime \@ "ddd dd MMM hh:mm am/pm" } = Thu 20 Oct 12:00 AM ????????? { MERGEFIELD CSCS_Test_DateTime } = Sat 20 Oct 11:00 AM It looks like the date/time format is failing - sent out all my appointments wrong today - but it's fine now without the formatting? "macropod" wrote in message ... Hi Graham, Sorted in the mailmerge field forum. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Graham Mayor" wrote in message ... JethroUK© wrote: The source is e.g. Thu 18 Oct 06:00 PM {Mergefield "CSCS_Test_DateTime" } (after DDE connection) is same: Thu 18 Oct 06:00 PM What does the field produce with the default connection - ie what is the underlying data in the source? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
#17
|
|||
|
|||
Is there a Special method to inserting fields?
How exactly are you arranging to use the longer format for future dates and
the shorter one for past dates? -- Peter Jamieson http://tips.pjmsn.me.uk "JethroUK©" wrote in message ... Hi It works fine without the formatting - it currently shows full date/time if the appoinment is pending: Sat 20 Oct 11:00 AM And short date once it has passed (becomes history) 20-Oct which is perfect for me - but just for interest - It is a proper date/time field formatted in XL as: ddd dd mmm hh:mm AM/PM (not text) i often leave out the year in the format but for sure it is 2007 - i don't know, but if it is being translated as text it's just guessing and it's guessing wrong "macropod" wrote in message ... Hi Jethro, Is this an actual date & time in Excel, or just a string? If it's an actual date & time, what *year* is in the Excel data? Cheers -- macropod [MVP - Microsoft Word] ------------------------- "JethroUK©" wrote in message ... Sort of - it works but still bugging out: XL Source = Sat 20 Oct 11:00 AM { MERGEFIELD CSCS_Test_DateTime \@ "ddd dd MMM hh:mm am/pm" } = Thu 20 Oct 12:00 AM ????????? { MERGEFIELD CSCS_Test_DateTime } = Sat 20 Oct 11:00 AM It looks like the date/time format is failing - sent out all my appointments wrong today - but it's fine now without the formatting? "macropod" wrote in message ... Hi Graham, Sorted in the mailmerge field forum. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Graham Mayor" wrote in message ... JethroUK© wrote: The source is e.g. Thu 18 Oct 06:00 PM {Mergefield "CSCS_Test_DateTime" } (after DDE connection) is same: Thu 18 Oct 06:00 PM What does the field produce with the default connection - ie what is the underlying data in the source? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org |
|
Thread Tools | |
Display Modes | |
|
|