![]() |
|
#1
|
|||
|
|||
![]()
Thanks, that worked, and it's so simple! Weird that the tome doesn't make it clear. They should change this:
To force DATE fields to convert to their results (ie so that they become static dates), reflecting the date on which the merge was performed, simply embed them in a QUOTE field coded along the lines of:To this: To force DATE fields to convert to their results (ie so that they become static dates), reflecting the date on which the merge was performed, simply embed them in a QUOTE field by pressing Ctrl+F9 twice to get two nested pairs of field braces, and type QUOTE after the first brace and DATE after the 2nd brace, like this: |
#2
|
||||
|
||||
![]()
The 'they' in this case is me, and I'm not inclined to make that example inconsistent with the rest of the examples in the thread. The instructions in that example, if followed correctly, will produce the same result as the workaround I gave you.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
Interesting how it becomes uneditable, even in the original doc, after doing a merge. So if you want to just change the date formatting, you have to scrap it and start over. Or is there a way to make it go back into editable form?
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
Adding text before a date merge field AND fomatting date as well | NikkiR | Mail Merge | 1 | 08-06-2014 07:18 PM |
Date field inserting merge date in blank field | Lesley | Mail Merge | 5 | 09-30-2013 01:49 AM |
![]() |
borntorun75 | Mail Merge | 3 | 12-16-2011 06:28 AM |
Wrong date with CreateDate | Blablub | Word | 0 | 02-18-2010 04:20 AM |