Home All Groups Group Topic Archive Search About

Which Locale ID (LCID) displays YYYY-MM-DD (ISO 8601)?



Author
13 Mar 2005 3:20 AM
Christian Perthen
Thanks in advance
Christian

Author
13 Mar 2005 3:28 AM
Christian Perthen
Found it. 1053 (Sweden)


Show quote
"Christian Perthen" <abracadab***@dontreplytothisaddress.com> wrote in
message news:eNy8nu3JFHA.616@TK2MSFTNGP10.phx.gbl...
> Thanks in advance
> Christian
>
>
Author
13 Mar 2005 4:27 AM
Aaron [SQL Server MVP]
Or, you could write a function instead of having LCID settings affect other
things (such as decimals).

http://www.aspfaq.com/2313



On 3/12/05 10:28 PM, in article eWZB1y3JFHA.2***@TK2MSFTNGP15.phx.gbl,
Show quote
"Christian Perthen" <abracadab***@dontreplytothisaddress.com> wrote:

> Found it. 1053 (Sweden)
>
>
> "Christian Perthen" <abracadab***@dontreplytothisaddress.com> wrote in
> message news:eNy8nu3JFHA.616@TK2MSFTNGP10.phx.gbl...
>> Thanks in advance
>> Christian
>>
>>
>
>
Author
15 Mar 2005 12:51 AM
Bullschmidt
And to make a variable be in the format of mm/dd/yyyy (and the final
line of code can be modifed for other date formats), perhaps try
something like the following which you might even make into a function
that you might put on a page that gets included in your main pages:

varFld = CDate(MyVariable)

intMonth = Month(varFld)
intDay = Day(varFld)
intYr = Year(varFld)

If intMonth < 10 Then
strMonth = "0" & CStr(intMonth)
Else
strMonth = CStr(intMonth)
End If

If intDay < 10 Then
strDay = "0" & CStr(intDay)
Else
strDay = CStr(intDay)
End If

strYr = Right(CStr(intYr), 4) ' And change the 4 to 2 for 2 year dates.

varFld = CStr(strMonth & "/" & strDay & "/" & strYr)

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

AddThis Social Bookmark Button