ASP Date/Time SQL data type within IE6 
Author Message
 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  
 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  
 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  
 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  
 
 [ 4 post ] 

 Relevant Pages 

1. Correct Syntax for Date/Time data types in SQL statements

2. FILE UPLOAD FROM ASP TO SQL SERVER TEXT DATA TYPE

3. Compare date in form with date/time in form with date/time in database

4. Date/Time data type in Access 97

5. HELP: Date/Time data type....

6. crystal reports abd date/time data type ?

7. incorrect data type with date variables in SQL

8. SQL Image Data Type in ASP

9. Problem accessing record from SQL Data base Date/Time Field

10. Convert date serial to a date data type

11. start date/time, end date/time problem

12. Insert date type varible through ODBC SQL server driver to SQL 7.0 database

 

 
Powered by phpBB® Forum Software