Time Format

A

Andy

Hi;

Have been searching for a way to format time in a mail merge.

The data source comes from Access 2k.

It now displays 09:05:00AM, need it to display 9:05am.

Can this be done?

Would someone be so kind to point me in the correct direction.

Andy
 
G

Graham Mayor

Add a formatting switch to the field eg {mergefield fieldname \@ "h:mm
am/pm"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
A

Andy

Graham;

Thank You.

Andy


Graham Mayor said:
Add a formatting switch to the field eg {mergefield fieldname \@ "h:mm
am/pm"}

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top