Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields,microsoft.public.word.newusers
|
|||
|
|||
Is there a Special method to inserting fields?
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a Special method to inserting fields? | Microsoft Word Help | |||
Is there a Special method to inserting fields? | New Users | |||
How do I retain special fields {} in a merge document? | Mailmerge | |||
Inserting SEQ Fields | Microsoft Word Help | |||
Inserting Merge Fields | Mailmerge |