Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
Tricky! However
{QUOTE{ = { Mergefield MyDate } \# "00'/'00'/'0000" } \@ "dd MMMM yyyy" } should work, where MyDate is the field with the numbers. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org wrote: 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 |
#3
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
On 8 Aug, 15:29, "Graham Mayor" wrote:
Tricky! However {QUOTE{ = { Mergefield MyDate } \# "00'/'00'/'0000" } \@ "dd MMMM yyyy" } should work, where MyDate is the field with the numbers. -- Graham Mayor - Word MVP My web sitewww.gmayor.com Word MVP web sitehttp://word.mvps.org wrote: 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- Hide quoted text - - Show quoted text - Graham That worked perfectly! I would never have worked it out on my own. Thank you very, very much! Darryl |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need to convert mm/dd/yyyy dates to textual date in MS Word | Microsoft Word Help | |||
How to globally disable "{TIME \@ "MMMM d, yyyy"}" | Microsoft Word Help | |||
My Date Insert Function in Office XP prints {DATE\@"MMMM d, YYYY" | Microsoft Word Help | |||
Insert date as MMMM d, yyyy from merged data | Mailmerge | |||
Forumla for converting dates into days | Tables |