Dates not working right, MM switching with DD

[CzechNET]

Hello,

I have a strange situation with a script I wrote. I have a script that uses dates extensively, user can select a date from 3 drop down menus (dd/mm/yyyy), save it to the database, then the entry is queried for specific date and then the entry is displayed. (In a nutshell

Now when I run the script on a server with UK locale the dates get assembled correctly, saved in the database correctly, when queried for a specific date it works correctly, but as soon as I fill a recordset the dates switch from dd/mm/yyyy to mm/dd/yyyy
and only if the day value is less then 10, so for example May 3rd would end up being displayed and read by ASP as March 5th, even though the database has the date corectly. Any ideas why it would happen and how I can fix it ? LCID is set to UK.

 

[Bastien]

ASP default format date. I take the string apart and reformat it manually to what i need...

Bastien

Cat, the other other white meat

 

[CzechNET]

Where do you set the default format ? Taking it apart won't work because ASP already thinks the days are month and vise versa so I'd end up with the same date, plus it only screws up when days are less then 10, if days are say 22 (of March) the date will show up correctly.

 

[mit99mh]

what db are you using?

If using SQL Server you can format the date using:

CONVERT ( data, 103 ) should give dd/mm/yy

It's covered well in BOL and this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

If using another db there may be comparable CONVERT functions

 

[CzechNET]

I'm using both Access and MS-SQL for this app, though the dates ARE saved correctly, but as soon as I fill a recordset they get screwed. I don't really think that the SQL convert will help much, but I'll give it a try.

 

[Sheco]

Maybe the CDate function will help. Perhaps if you saved it as a string in the database... instead of as a date field.

I am assuming that CDate() will create the same value for "January 2 2005" as it does for "2 January 2005" ... but I'm too lazy to test it.

 

[Sheco]

OK, I lied... I'm not THAT lazy. I tested it and it seemed to work.

<%@ Language=VBScript %>
<%
Dim A, B
A = CDate("Jan 2 2005")
B = CDate("2 Jan 2005")
Response.Write "Result: " & cStr(cBool(A = B))
%>

 

[CzechNET]

That'd be going into a wrong direction, saving a date value in a string would limit you in a lot ways.

 

[nicklieb]

I've had this problem it's been higlighted in the microsoft report.

http://support.microsoft.com/?scid=.../servicedesks/bin/kbsearch.asp?article=271587

follow this and it should clear the problem ( it did for me! )