how to set correct date format

[Himanshu Dora]

Hi
I have set with lcid value. but i am not able to overcome my nt server
regional setting. Actually i want a date in mm/dd/yyyy. But i get date as
mm/dd/yy. How to ensure that i shall always get correct format irrespective
of os or regional setting.

regards
himanshu

[Bob Barrows]

Himanshu Dora wrote:

Hi
I have set with lcid value. but i am not able to overcome my nt
server regional setting. Actually i want a date in mm/dd/yyyy. But i
get date as mm/dd/yy. How to ensure that i shall always get correct
format irrespective of os or regional setting.

Convert the date to a string with the proper format using the various date
functions available: day(), month(), year(). This way, you are in control,
rather than the Regional Settings.

Bob Barrows

[Aaron Bertrand [MVP]]

http://www.aspfaq.com/2260
http://www.aspfaq.com/2313

"Himanshu Dora" <hi**********@hotmail.com> wrote in message
news:u#**************@TK2MSFTNGP10.phx.gbl...

Hi
I have set with lcid value. but i am not able to overcome my nt server
regional setting. Actually i want a date in mm/dd/yyyy. But i get date as
mm/dd/yy. How to ensure that i shall always get correct format irrespective of os or regional setting.

regards
himanshu

[Bullschmidt]

To make a variable be in the format of mm/dd/yyyy, perhaps try something
like the following which you might even make into a function:

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!