473,322 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Making dates British....


Hi folks,

We have two servers running ASP.NET systems. One is live and one is
development. I have recently adopted an ASP system from a colleague to
nurse it back to health. On the development server it correctly interprets
dates as being british i.e. dd/mm/yyyy, but on the live server it reverts to
the usa format i.e. mm/dd/yy.

Both systems have the appropriate session variable set i.e. Session.LCID =
2057. Both servers have IIS set up in exectly the same way and I'm not in
any way sure that IIS has a say over this in any case.

Any ideas??

Cheers....P
Jul 22 '05 #1
5 1773
Paul Mason wrote:
Hi folks,

We have two servers running ASP.NET systems.
There was no way for you to know it, but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-savvy person here who can
answer your question, you can eliminate the luck factor by posting your
question to a newsgroup where the dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.

One is live and one is
development. I have recently adopted an ASP system from a colleague
to nurse it back to health. On the development server it correctly
interprets dates as being british i.e. dd/mm/yyyy, but on the live
server it reverts to the usa format i.e. mm/dd/yy..


This is probably due to the Regional settings for the aspnet user. Check
with the dotnet people for confirmation.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 22 '05 #2
You have also both system settings and profile based settings for this. Are
they identical ? On which account do they run ? You also have to add the
corresponding language support installed (if I remember this is already the
case for most languages but you may want to check).

Frankly we had once quite numerous problems with this (such as french month
names with US formatting !!!).

My personal preference under ASP is to use my own formatting functions so
that the application doesn't depend on the server configuration. Under
ASP.NET they now handle this as the ASP.NET Application level so that server
setting are no more relevant (which is good IMO).

Patrice

--

"Paul Mason" <p.*******@bham.ac.uk> a écrit dans le message de
news:eJ**************@TK2MSFTNGP12.phx.gbl...

Hi folks,

We have two servers running ASP.NET systems. One is live and one is
development. I have recently adopted an ASP system from a colleague to
nurse it back to health. On the development server it correctly interprets dates as being british i.e. dd/mm/yyyy, but on the live server it reverts to the usa format i.e. mm/dd/yy.

Both systems have the appropriate session variable set i.e. Session.LCID =
2057. Both servers have IIS set up in exectly the same way and I'm not in
any way sure that IIS has a say over this in any case.

Any ideas??

Cheers....P

Jul 22 '05 #3

Hi,

This app is classic ASP. The first bit of spiel was misleading. I'm used
to ASP.NET more than ASP these days.

We've managed to narrow the problem down to being something to do with SQL
server. I failed to mention we have two SQL servers (live and dev again)
and that when we connect the live web server to the development SQL server
the system works correctly. It appears that the two SQL implementations are
both set up correctly, so the only difference now is the fact that the
working server (dev) is Windows 2000 server and the broken one (live) is
Windows 2003 server...

If push comes to shove we'll drop the live system onto the development
server...

Cheers...P

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Paul Mason wrote:
Hi folks,

We have two servers running ASP.NET systems.


There was no way for you to know it, but this is a classic asp newsgroup.
While you may be lucky enough to find a dotnet-savvy person here who can
answer your question, you can eliminate the luck factor by posting your
question to a newsgroup where the dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.

One is live and one is
development. I have recently adopted an ASP system from a colleague
to nurse it back to health. On the development server it correctly
interprets dates as being british i.e. dd/mm/yyyy, but on the live
server it reverts to the usa format i.e. mm/dd/yy..


This is probably due to the Regional settings for the aspnet user. Check
with the dotnet people for confirmation.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Jul 22 '05 #4
No, it's got nothing to do with SQL Server - it has to do with the regional
settings for the IUSR account on the live server. The default is US format.

See these articles for more information:
http://www.aspfaq.com/show.asp?id=2313 vbscript
http://www.aspfaq.com/show.asp?id=2040 help with dates
http://www.aspfaq.com/show.asp?id=2260 dd/mm/yyy confusion

Paul Mason wrote:
Hi,

This app is classic ASP. The first bit of spiel was misleading. I'm
used to ASP.NET more than ASP these days.

We've managed to narrow the problem down to being something to do
with SQL server. I failed to mention we have two SQL servers (live
and dev again) and that when we connect the live web server to the
development SQL server the system works correctly. It appears that
the two SQL implementations are both set up correctly, so the only
difference now is the fact that the working server (dev) is Windows
2000 server and the broken one (live) is Windows 2003 server...

If push comes to shove we'll drop the live system onto the development
server...

Cheers...P

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Paul Mason wrote:
Hi folks,

We have two servers running ASP.NET systems.


There was no way for you to know it, but this is a classic asp
newsgroup. While you may be lucky enough to find a dotnet-savvy
person here who can answer your question, you can eliminate the
luck factor by posting your question to a newsgroup where the
dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.

One is live and one is
development. I have recently adopted an ASP system from a colleague
to nurse it back to health. On the development server it correctly
interprets dates as being british i.e. dd/mm/yyyy, but on the live
server it reverts to the usa format i.e. mm/dd/yy..


This is probably due to the Regional settings for the aspnet user.
Check with the dotnet people for confirmation.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
Jul 22 '05 #5

Thanks...will get my folks to look at this tomorrow.

Cheers..P

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:eW**************@TK2MSFTNGP15.phx.gbl...
No, it's got nothing to do with SQL Server - it has to do with the
regional
settings for the IUSR account on the live server. The default is US
format.

See these articles for more information:
http://www.aspfaq.com/show.asp?id=2313 vbscript
http://www.aspfaq.com/show.asp?id=2040 help with dates
http://www.aspfaq.com/show.asp?id=2260 dd/mm/yyy confusion

Paul Mason wrote:
Hi,

This app is classic ASP. The first bit of spiel was misleading. I'm
used to ASP.NET more than ASP these days.

We've managed to narrow the problem down to being something to do
with SQL server. I failed to mention we have two SQL servers (live
and dev again) and that when we connect the live web server to the
development SQL server the system works correctly. It appears that
the two SQL implementations are both set up correctly, so the only
difference now is the fact that the working server (dev) is Windows
2000 server and the broken one (live) is Windows 2003 server...

If push comes to shove we'll drop the live system onto the development
server...

Cheers...P

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Paul Mason wrote:
Hi folks,

We have two servers running ASP.NET systems.

There was no way for you to know it, but this is a classic asp
newsgroup. While you may be lucky enough to find a dotnet-savvy
person here who can answer your question, you can eliminate the
luck factor by posting your question to a newsgroup where the
dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.
One is live and one is
development. I have recently adopted an ASP system from a colleague
to nurse it back to health. On the development server it correctly
interprets dates as being british i.e. dd/mm/yyyy, but on the live
server it reverts to the usa format i.e. mm/dd/yy..

This is probably due to the Regional settings for the aspnet user.
Check with the dotnet people for confirmation.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get
a quicker response by posting to the newsgroup.


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Jul 22 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

114
by: muldoon | last post by:
Americans consider having a "British accent" a sign of sophistication and high intelligence. Many companies hire salespersons from Britain to represent their products,etc. Question: When the...
12
by: David Lindsay | last post by:
I want to put date and time on my web page, and to be sure it tracks the BST/ GMT changes. Can anyone help me, I have gone back in my historic file for quite a while and not found anything. Sorry...
52
by: Andy Dingley | last post by:
I'm using this at present: <p title="Publication date" ></p> Works fine on screen, but Fangs/Jaws just reads it as "left bracket twenty-eight slash zero slash two thousand five fifteen colon...
13
by: tshad | last post by:
I have a dataset with a date in it. The type is smalldatetime on Sql Server and I am just doing a "SELECT * from x" to get it. All my other fields are fine, but this one gives me an error of: ...
1
by: luna | last post by:
sql query in code looks like this :- sql = "INSERT INTO livetracker (ID,MortgageSourced,PostalPackIssued,PostalPackReturned,SalesManager,Mortgag...
9
by: Simon Harvey | last post by:
Hi all, I'm having a bit of a problem working with dates. My computer is british, but I'm developing an american application so I therefore need to use american dates. But I can't get my...
1
by: santiago | last post by:
Hello. I'm having troubles with a query that (should) return all the records between two dates. The date field is a datetime type. The db is SQL Server 2000. When I try this SELECT ...
1
by: Taftheman | last post by:
Hi as i live in britain it would be nice if i have my dates as dd/mm/yyyy not mm/dd/yyyy I have an import process and it all begins when i use a dts package to import the access data into sql. The...
5
by: Smokey Grindle | last post by:
Ok I must admit I stink at regular expressions... been trying to learn them for a while now and its not sticking how I wish it would... but I am trying to take a very long string (about 30KB) and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.