[laandmc]

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

[Suzanne S. Barnhill]

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" wrote in message
...
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

[Suzanne S. Barnhill]

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" wrote in message
...
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