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