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