I'm designing a web database where users can enter a date. It is in the format dd/mm/yyyy. I've set MS ACCESS up with the field as short format dd/mm/yyyy. When a user adds a record all is fine, the date enter the DB as intended, but when it is retieved through a results page it is in the format mm/dd/yyyy. I've checked my PC date/time settings but these are definitely dd/mm/yyyy

Is there anything I've overlooked??

Thanks

ULTRADEV, ASP, VBSCRIPT, WIN2000/IIS5, MS ACCESS

When you bind the field to the page (drag and drop) there is a format option that will allow you to change how the date is displayed. By default this is set to mm/dd/yyyy.

Regards
Vince

Response.write("The best line of code you can ever use"

VBScript | ASP | HTML | SQL | Oracle | Hosting

To view dates from database Date/Time fields in different formats you can use the Session.LCID property.

E.g.: < % session.LCID = "2057" % >

Place this at the top of your ASP page. This will display dates in UK format (DD/MM/YYYY) hope this helps as you look like your trying to get UK format.

********************
wheatNOTmeat