... boy what a timely post.  I was just getting ready to discard my response
to a previous poster, but it addresses this question pretty much head on.
Check it out - as well as search the archives for other of my <pet peeve>
posts which are mostly about these types of issues...

Regards,
Tore.

-----Original Message-----
From: Erik Petersen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 5:46 PM
To: ActiveServerPages
Subject: Dates driving me crazy.



Hi,

Here is my issue:

I have a multi-layer web architecture: SQL -> COM -> Display (ASP). We pass
dates between layers as explicitly formatted strings, so they don't get
affected by the date settings.

When I am physically logged into the computer, the date presentation is:

 dd/mm/yyyy, date functions (CDate, Dateserial) return dates as dd/mm/yyyy.

If I log off, and nobody is logged in, date presentation is dd/mm/yyyy,
because we pass dates as strings, but date functions (Cdate, dateserial)
return dates as (mm/dd/yyyy).

I've followed the instructions on setting the default locale in regional
settings, including the re-boot required for this, my default is
English(Canada), and I am still not having any luck.

The LocaleID doesn't change when logged in/not logged in.

I've checked the registry under hklm/hkey_users/.default/control
panel/international to see the format and it still says country "United
States".

I need this because we are doing date comparisons, and they are all breaking
unless someone is physically logged in.

WIN2k service patch 3.

Any tips, or experience would be appreciated.

Thanks

Erik



---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%

---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to