ADO Connection with ASP & MS ACCESS

[tyleri]

I am running my work on a Win2k server.
I am using MS Access as my database.

I have a date field, and it is formatted like this: 10/21/2002.

How can I make it say "MONDAY, October 21"? I want the user to be able to enter the date as 10/21/2002.

Can this be done in a query in my ASP form? If so, could you show me how!?

ALSO - what command would I use to select only the most recent 5 records ( i have an autonumber field in the database).

 

[dollarbill]

You can use the following query in MSAccess to format the date after they enter it.
SELECT Format([YourDateField],"dddd"", ""mmm d&quot AS NameForYourDateField
FROM tblDate;
The help files in Access list the symbols available to customize your date.
Hope this helps.