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