Helder Meneses
|
| Posted: 01/18/2002, 1:38 AM |
|
hi there, i cant make my web page to format date in european format...
how can i make this in ASP???
thank you...
helder.meneses@oninet.pt
|
|
|
 |
Nicole
|
| Posted: 01/18/2002, 3:22 AM |
|
Helder,
try add to Open Any Page event under Modules section proper Session.LCID, e.g. French LCID
Session.LCID = &H040c
The full list you can find in MSDN
|
|
|
|
walter
|
| Posted: 01/18/2002, 3:22 AM |
|
Hi, helder.
Had the same problem. Now this helps alot:
I a record form go to record properties and events;
Before show event type ( VBScript )
If IsDate(fldDATE) Then
fldDATE = DatePart("d", fldDATE) & "." & DatePart("m", fldDATE) & "." & DatePart("yyyy", fldDATE)
End If
But you have to convert it right back in the
Before Insert/Before Update events like
If IsDate(fldDATE) Then
fldDATE = DatePart("yyyy", fldDATE) & "-" & DatePart("m", fldDATE) & "-" & DatePart("d", fldDATE)
End If
where SQL-date format is yyyy-mm-dd.
Cange "-" to "/" when your format is yyyy/mm/dd and so on.
In a grid form use Before Show event as well.
Hope that comes in handy,
walter
|
|
|
|
Nicole
|
| Posted: 01/18/2002, 4:16 AM |
|
Helder,
just in addition to Walter words I can say that your db could have another date format. Keep it in mind.
|
|
|
|
Ron Borkent
|
| Posted: 01/19/2002, 3:25 AM |
|
If you do this on a record form be sure to turn the thing around in before update or before insert event.
|
|
|
|
Mike
|
| Posted: 06/02/2002, 5:37 AM |
|
I have read the above solution but still have problems to see the European date (server is in the US)
1043 is for the Netherlands
in the asp page the following line was added
'===============================
' daysRecord OpenAnyPage Event begin
Session.LCID = 1043
' daysRecord OpenAnyPage Event end
'===============================
Can someone help me????
Thanks in advance
|
|
|
|
Arthur
|
| Posted: 06/03/2002, 1:53 AM |
|
Hello,
Please refer to the article that describes how to use different date formats:
http://www.gotocode.com/art.asp?art_id=132&
|
|
|
|
|
