date field format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lynn atkinson - 23 Mar 2005 15:11 GMT

I am working on a mail merge with an Access database as a data source. I want
the date on the merged letter to be in long date format ie wednesday 23 March
2005 and the time to be displayed in short format ie 14:00. I have formatted
the fields in the database to be such and the tables display in that format,
however when I complete the merge the date is displayed as 23/3/05 and the
time is 10:00:00.
How do I get the formats displayed as I require.

Reply to this Message

Greg - 23 Mar 2005 15:39 GMT

Try this switch in your mergefie

{ Mergefield YourField \@ "dddd, dd MMMM yyyy hh:mm"}

Reply to this Message

lynn atkinson - 23 Mar 2005 16:39 GMT

thanks
I have put this in place for the date and it works well. However, I have a
time field which is separate and although I have put the switch \@hh:mm in
place, it is showing the time 15:00 in the database as 03:00 in the merged
document. How do I get it to translate the 24hr clock times?

> Try this switch in your mergefie
>
> { Mergefield YourField \@ "dddd, dd MMMM yyyy hh:mm"}

Reply to this Message

Graham Mayor - 23 Mar 2005 17:59 GMT

Use upper case Hs for the 24 hour clock.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> thanks
> I have put this in place for the date and it works well. However, I
[quoted text clipped - 6 lines]
>>
>> { Mergefield YourField \@ "dddd, dd MMMM yyyy hh:mm"}

Reply to this Message

macropod - 05 Apr 2005 08:34 GMT

hi Lynn,

It's as simple as changing 'hh' to 'HH':
{ Mergefield YourField \@ "dddd, dd MMMM yyyy HH:mm"}

Cheers

> thanks
> I have put this in place for the date and it works well. However, I have a
[quoted text clipped - 5 lines]
> >
> > { Mergefield YourField \@ "dddd, dd MMMM yyyy hh:mm"}

Reply to this Message