Prev: notify clients of moving to a new company
Next: Creating multiply word documents
From: laandmc on 26 Apr 2010 07:59
I am using a template to get information out of a sequel database. One of the
fields is a date field which is displayed as dd/mm/yyyy

Is there a way to change the display to display it in words:

e.g.
05/05/2010 would be displayed as Wednesday 05 May 2010

Currently the line of code I am using to extract this information is
{tblDiaryAppointment/Start_Date} where tblDiaryAppointment is the sql table I
am drawing the information from
From: Suzanne S. Barnhill on 26 Apr 2010 08:47
Yes. See http://sbarnhill.mvps.org/WordFAQs/DateFields.htm for a summary of
the switches you can add to the DATE field. In this case, you want

{ DATE \@ "dddd dd MMMM yyyy" }

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"laandmc" <laandmc(a)discussions.microsoft.com> wrote in message
news:F54E96CA-E830-4821-987A-90296C9921C6(a)microsoft.com...
>I am using a template to get information out of a sequel database. One of
>the
> fields is a date field which is displayed as dd/mm/yyyy
>
> Is there a way to change the display to display it in words:
>
> e.g.
> 05/05/2010 would be displayed as Wednesday 05 May 2010
>
> Currently the line of code I am using to extract this information is
> {tblDiaryAppointment/Start_Date} where tblDiaryAppointment is the sql
> table I
> am drawing the information from
>

 | 
Pages: 1
Prev: notify clients of moving to a new company
Next: Creating multiply word documents