[Peter Jamieson]

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