Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Empty Date External field returns current date
Using Word 2002, Excel 2002:
Excel is the external data source Where a date field is blank, the merge field returns the current date. I've tried to eliminate with {IF {MERGEFIELD thatdate}="" "" "Date reported: {MERGEFIELD thatdate \@ etc}"}, but the result is the same. Thanks for listening..! Roger Shaftesbury (UK) |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Empty Date External field returns current date
If {Mergefield thatdate} produces the current date when empty, then basing
the condition on a nul result from an allegedly empty record isn't going to help. You have to work with what you actually get not what you think it should be. See is the Excel data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm helps. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Roger Whitehead wrote: Using Word 2002, Excel 2002: Excel is the external data source Where a date field is blank, the merge field returns the current date. I've tried to eliminate with {IF {MERGEFIELD thatdate}="" "" "Date reported: {MERGEFIELD thatdate \@ etc}"}, but the result is the same. Thanks for listening..! Roger Shaftesbury (UK) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Empty Date External field returns current date
Thanks Graham
I've selected an alternative connection method (can't remember which one now, but it works). R "Graham Mayor" wrote in message ... If {Mergefield thatdate} produces the current date when empty, then basing the condition on a nul result from an allegedly empty record isn't going to help. You have to work with what you actually get not what you think it should be. See is the Excel data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm helps. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Roger Whitehead wrote: Using Word 2002, Excel 2002: Excel is the external data source Where a date field is blank, the merge field returns the current date. I've tried to eliminate with {IF {MERGEFIELD thatdate}="" "" "Date reported: {MERGEFIELD thatdate \@ etc}"}, but the result is the same. Thanks for listening..! Roger Shaftesbury (UK) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use current date in the default date form field option | Microsoft Word Help | |||
Field codes - current date +90d | Microsoft Word Help | |||
Fillin field default to current date | Mailmerge | |||
How do I omit an empty date merge field? | Microsoft Word Help | |||
How to insert future date based on current date plus 14 days | Microsoft Word Help |