Date and Time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andrew C - 28 Oct 2005 08:06 GMT

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 to this Message

macropod - 28 Oct 2005 09:20 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> Andrew C

Reply to this Message