Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement,microsoft.public.word.mailmerge.fields
|
|||
|
|||
IF 06/11/2007 23/10/2007 = is "True" isn't it?
This is slowly (nay quickly) driving me insane - I have an mailmerge IF
condition to help me spot pending appointments easily If { MERGEFIELD Myfield \@ "dd/MM/yyyy" } { DATE \@ "dd/MM/yyyy" } { MERGEFIELD Myfield \@ "ddd dd MMM hh:mm" } {MERGEFIELD Myfield \@ "dd/MM"} pseudo = If myfield is after today (pending) then, display mydate in long date format, else mydate as short date format e.g.: IF 31/10/2007 23/10/2007 = "Wed 31 Oct 07:00" = great IF 22/10/2007 23/10/2007 = "22/10" = great After a week of (seemingly) no problems - Today I uncovered a gremlin IF 06/11/2007 23/10/2007 is returning "06/11" ????? - that's True isn't it? I have always had problems getting MS Word (XP 2002) to interpret UK/English dates - I thought after DDE connection (albeit it very incovenient) my troubles were over Just looking at these examples myself (as i type here) I can see that despite 06/11/2007 displayed in full, formatted correctly (UK day/month), interpreted (from XL) & displayed correctly, connected as DDE - this is 'still' just a fudge for the folks over in blighty - it is clearly evident that MS Word 'still' thinks this is US 11th June 2007 & i am about to try few more dates to confirm it Is it fair to say MS Word just doesn't know what day it is? Or am I missing something obvious or do I give up gracefully? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF 06/11/2007 23/10/2007 = is "True" isn't it? | Microsoft Word Help | |||
Word 2007: "Keep with next" and "Widow Lines" features not workin | Microsoft Word Help | |||
Word 2007 view defaults to "Thumbnails" rather than "Document Map" | Microsoft Word Help | |||
Word 2007 and Powerpoint 2007 "close window" button | Microsoft Word Help | |||
How do I convert all "NAME" to "Name" in MS Word 2007 document? | Microsoft Word Help |