Converting Word dates from ddmmyy into dd MMMM yyyy

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DarrylGould@googlemail.com - 08 Aug 2007 14:30 GMT

Hello

Can anyone help? I am performing a Word mailmerge from a source that
cannot be amended. The dates in the source are stored in ddmmyy
format, i.e. 08082007 for today's date. I need to display the dates
as dd MMMM yyyy format, i.e. 08 August 2007. Does anyone now I can do
so?

Many thanks
Darryl

Reply to this Message

Graham Mayor - 08 Aug 2007 15:29 GMT

Tricky! However
{QUOTE{ = { Mergefield MyDate } \# "00'/'00'/'0000" } \@ "dd MMMM yyyy" }
should work, where MyDate is the field with the numbers.

Signature

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

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

> Hello
>
[quoted text clipped - 6 lines]
> Many thanks
> Darryl

Reply to this Message

DarrylGould@googlemail.com - 08 Aug 2007 15:55 GMT

> Tricky! However
> {QUOTE{ = { Mergefield MyDate } \# "00'/'00'/'0000" } \@ "dd MMMM yyyy" }
[quoted text clipped - 21 lines]
>
> - Show quoted text -

Graham

That worked perfectly! I would never have worked it out on my own.
Thank you very, very much!

Darryl

Reply to this Message