IIS 6.0 - Date and time format issue.

I came across an interesting problem at work...Simple but took time to figure it out and resolve it. Just to give you an outline...A reports based .net application is served through IIS6.0.....users can upload, query download records everyone is happy great...now the application was written in USA and the servers are hosted in Europe so when the users were querying the records some of them get errors saying unable to find the record...in some cases instead of getting 30 records they get 200. The reason was the server date format was in DD/MM/YY and as we know US uses MM/DD/YY. So far good...fig out what is wrong...now how to resolve this. Just changing the system time via Control panel - Date & time will not help.
IIS6.0 gets its date/time from the following registry key - HKEY_USERS\.default\Control Panel\International registry hive. Made the modification here and issue was resolved.
Just as an FYI...when the system time is changed via Control panel - Date & time the following key is modified and this key give out date & time to the users whose profiles exist on the machine - HKEY_LOCAL MACHINE\...\Control Panel\International....but in this case the users log on to the app like any from a web front end so they don't have a profile on the server. hope this post makes sense...and benefits someone.

VC

Hi This is my first Blog Posting and it is about Truth and Honesty.

I came across many people who are all about T&H...preach a lot. But don't practice it. Wass up with that???