
ASP Date/Time SQL data type within IE6
I've had similar problems in the past, check the page under two conditions,
whilst logged into the server itself and check the date displayed on the
page, then check whilst logged out if you get two differing formats, then
its not an ie issue, what's going on is during installation the correct
regional settings weren't set, changing them whilst logged in doesn't affect
the base settings i.e. when logged out, there's a registry fix in the
knowledge base to allow you to enforce the regional settings for IIS.
hope this is of some help
Quote:
> I have a database driven intranet app which captures dates from the user
> and stores them in a table within a "date/time" data type in an access
> DB. The format within the data table is SHORT DATE, giving me DD/MM/YYYY
> appearance. This displayed via an asp page just fine under IE 5 and 5.5,
> but after an upgrade to IE6 the asp page is now displaying the dates as
> MM/DD/YYYY without any changes being made to the database....
> Has anyone got any idea of why this happens and how to correct it? I
> would be very grateful if you could let me know.
> Many thanks,
> Mark.
> --
> Posted via http://dbforums.com