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