Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date and Time
I have merge information and dates from an access database. When the dates
are inserted it also shows a time. I only need to show the date. What do i have to do to fix this to only show date only. Regards Andrew C |
#2
|
|||
|
|||
Date and Time
Hi Andrew,
the solution is as simple as adding a date 'picture switch' to your merge field: 1. Select the field and press Shift-F9. You should see something like {MERGEFIELD AccessDate} 2. Add a date 'picture switch' to the field so that it looks like any one of: {MERGEFIELD AccessDate \@ "dddd, d MMMM yyyy"}, or {MERGEFIELD AccessDate \@ ", d MMMM yyyy"}, or {MERGEFIELD AccessDate \@ "d MMM yyyy"}, or {MERGEFIELD AccessDate \@ "dd/MMM/yyyy"}, or {MERGEFIELD AccessDate \@ "d-MM-yy"} etc 3. Press F9 to update the field 4. Run your mail merge. Cheers "Andrew C" wrote in message ... I have merge information and dates from an access database. When the dates are inserted it also shows a time. I only need to show the date. What do i have to do to fix this to only show date only. Regards Andrew C |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date field switch so it doesn't update every time you open docume. | Microsoft Word Help | |||
keyboard shortcut for create date & time | Microsoft Word Help | |||
how do i embed a date so it doesn't update next time doc is used? | Microsoft Word Help | |||
Date & Time auto update | Microsoft Word Help | |||
How to prevent Merged Date Field showing time? | Mailmerge |