Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date formats in Windows 2000

Status
Not open for further replies.
pancake

pancake

Programmer
Aug 21, 2001
88
GB

I have a Front page web that runs ok on our server. I copied the web onto another server - without any problems, and it displays all the database results. However the date fetched from database results is not displaying correctly.

Instead of 31/12/02 I get 12/31/02

The Date in the database is held in the correct format, and both server settings are set to UK / English. The only difference in the servers is the old server is Windows NT and the new one Windows 2000.

Any help would be much appreciated.

Thanks
 
Sort by date Sort by votes
Not sure why you should be getting problems changing from NT to 2000, however I've never run webs or databases from NT in the past so I can't help you there. Sorry.

Anyhoo, you're doing database stuff, so I've assumed you're using Active Server Pages so just try adding this to the top of any page that contains dates - just above the <html> tag will do:

Code: 
<% Session.LCID = 2057 %>

It ensures all your dates are displayed in UK format. Dates are a problem that everyone has had trouble with in the past, but there are several work arounds.

Hope this is what you're looking and helps you out.

Craig
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Upload index.htm in FrontPage does not work well
Replies
0
Views
285
leifoet
leifoet
leifoet
  • Locked
  • Question
Select query in Frontpage is not working
Replies
0
Views
273
leifoet
leifoet
sap1958
  • Locked
  • Question
Frontpage 2003 Not Compatible with Windows 7 1
Replies
7
Views
390
xwb
xwb
dieseldrvr
  • Locked
  • Question
Protect My Videos From Being Ripped In Iphone or Android Format??
Replies
0
Views
86
dieseldrvr
dieseldrvr
RM6002
  • Locked
  • Question
Opening page in Frontpage from Access
Replies
4
Views
99
xwb
xwb

Part and Inventory Search

Sponsor

Back
Top