vbscript, ASP Date/Time SQL data type within IE6

ASP Date/Time SQL data type within IE6

Author	Message
Mark Mitc #1 / 4	ASP Date/Time SQL data type within IE6 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://www.--*.com/
Sun, 03 Jul 2005 04:29:09 GMT

Mark McNall #2 / 4	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
Mon, 04 Jul 2005 10:27:15 GMT

Mark Mitc #3 / 4	ASP Date/Time SQL data type within IE6 Thanks Mark, sorry to bother you again but any chance or a URL to this fix? Im not sure where the Knowledge base you mentioned is located! (doh!) Thanks Mark. Originally posted by Mark McNally Quote: > 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 > bforums.com[/url]... > > 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/http://dbforums.com -- Posted via http://dbforums.com
Tue, 05 Jul 2005 06:18:45 GMT

MVP #4 / 4	ASP Date/Time SQL data type within IE6 Quote: > Thanks Mark, sorry to bother you again but any chance or a URL to > this fix? Im not sure where the Knowledge base you mentioned is > located! (doh!) Probably one of these... INFO: Behavior of Date/Time Format Differs When Accessed from Active Server Pages (Q306044) http://support.microsoft.com/default.aspx?kbid=306044 VBScript Date and Time Functions May not be Formatted Properly http://support.microsoft.com/default.aspx?kbid=264063 PRB: VBScript Date and Time Formats Change with Logged on User (Q218964) http://support.microsoft.com/default.aspx?kbid=218964 -- Michael Harris Microsoft.MVP.Scripting Seattle WA US
Tue, 05 Jul 2005 11:16:37 GMT

Page 1 of 1

[ 4 post ]