Formatting DB date field in an ASP page

[EdRev]

I have a date field on an Access database that has a longdate format (Thursday, July 04, 2003).

When I retrieved this field into my asp page
<%=dateset(&quot;datefld&quot%>, the format was changed to 7/4/03.
How can I format it to July 4, 2003?

Any help will be greatly appreciated.

 

[Chopstik]

You could use the FormatDateTime() function. Chances are you would want to use the LongDate format.

--------------------------------------------------------------------------------------------------------------------------
Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
--Douglas Adams