sorting date by day/month/year

[ulthane]

Hey guys,
im trying to get the Date by using the Date() function or objFile.DateLastModified (2 different pages)

on my localhost it appears fine, the order wanted is day/month/year

But on brinkster (my web hosting) it is ordered Month/day/year...

is there any way of changing this to day/month/year?

thanks for the help

[webber123456]

there's something new out called "google"

you should try it with the phrase "UK vs US date vbscript"

I found this in about 5 seconds:

<%
Dim MyString, UKDate, USDate
MyString = Request.Form("Date")
UKDate = Split(MyString, "/", -1, 1)
' UKDate(0) contains "DD".
' UKDate(1) contains "MM".
' UKDate(2) contains "YY".
USDate = UKDate(1) & "/" & UKDate(0) & "/" & UKDate(2)
%>

I'm sure you can adapt it to your needs

[DaveMaxwell]

there's something new out called "google"

you should try it with the phrase "UK vs US date vbscript"

I found this in about 5 seconds:

Actually, a more consistent approach would be to set the locale (which will set the date format accordingly).

http://www.w3schools.com/VBscript/func_setlocale.asp

[webber123456]

Actually, a more consistent approach would be to set the locale (which will set the date format accordingly).

http://www.w3schools.com/VBscript/func_setlocale.asp

That link is for client-side vbscript and only works in IE browser.

As I said, I only spent 5 seconds on this.

If you want to use LCID for ASP this may be of some use. Again, I found this with google very quickly...

http://msdn.microsoft.com/en-us/libr...8VS.90%29.aspx

[ulthane]

well i cant make it to work, i use it like that:

<%
Dim MyString, UKDate, USDate
MyString = Date()
UKDate = Split(MyString, "/", -1, 1)
' UKDate(0) contains "DD".
' UKDate(1) contains "MM".
' UKDate(2) contains "YY".
USDate = UKDate(0) & "/" & UKDate(1) & "/" & UKDate(2)
%>

and it still displays it as M/D/Y

SetLocale didnt work either (and yeh im using Chrome)

[webber123456]

well i cant make it to work, i use it like that:

<%
Dim MyString, UKDate, USDate
MyString = Date()
UKDate = Split(MyString, "/", -1, 1)
' UKDate(0) contains "DD".
' UKDate(1) contains "MM".
' UKDate(2) contains "YY".
USDate = UKDate(0) & "/" & UKDate(1) & "/" & UKDate(2)
%>

and it still displays it as M/D/Y

SetLocale didnt work either (and yeh im using Chrome)

you need to learn to debug the code. verify the original date format and compare to the adjusted to learn why desired results are not being obtained.

 
MyString = Date()
Response.Write "original : <B>" & MyString & "</B><BR>"
UKDate = Split(MyString, "/", -1, 1)
 
' UKDate(0) contains "DD".
' UKDate(1) contains "MM".
' UKDate(2) contains "YY".
 
USDate = UKDate(0) & "/" & UKDate(1) & "/" & UKDate(2)
Response.Write "revised: <B>" & USDate & "</B><BR>"

correct positions as needed....

[ulthane]

thanks, worked now the problem was that 0 contained the month and 1 contained the day