Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Date always shows as 30/December/1899???
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Date always shows as 30/December/1899???

 Post Reply Post Reply
Author
agentchristoph View Drop Down
Groupie
Groupie


Joined: 25 August 2002
Location: Canada
Status: Offline
Points: 186
Post Options Post Options   Thanks (0) Thanks(0)   Quote agentchristoph Quote  Post ReplyReply Direct Link To This Post Topic: Date always shows as 30/December/1899???
    Posted: 18 May 2003 at 1:29pm

Hi,

Having a little problem with my board setup. The dates are entered fine into the SQL server database, but on the board, they ALL display as: 30/December/1899 at 00:00

I've tried changing the LCID setting to a whole number of values, none of which made any difference. Also been through (I think) every combination of date/time format in the admin section but still nothing.. anyone any ideas??

An example of a date from the database: 16/05/2003 00:40:31

Thanks,

Chris.

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2003 at 4:07am

Check that the SQL server is set to teh same locale as the web server.

Also try re-uploading the forum again.

Back to Top
Vinay View Drop Down
Newbie
Newbie
Avatar

Joined: 23 November 2002
Location: United Kingdom
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote Vinay Quote  Post ReplyReply Direct Link To This Post Posted: 20 May 2003 at 3:01am

Guys,

I am having the same problem. There may be a slight twist to it because, the date and time '30 December 1899 at 12:00am' only appears when a person is logged in. As soon as you logout of the forum, the correct times appear. I have looked at the SQL Server tables and they seem to be fine. I am using v7.01

Your help is appreciated.

Thanks

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 20 May 2003 at 5:28am
On waht parts is the date shown in this format?
Back to Top
Vinay View Drop Down
Newbie
Newbie
Avatar

Joined: 23 November 2002
Location: United Kingdom
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote Vinay Quote  Post ReplyReply Direct Link To This Post Posted: 21 May 2003 at 7:27am

Got it sussed!

I have edited the registration page to remove some of the fields that I did not want. This also included the time offset and date format fields. Have created two hidden text fields for this info now.

Cheers

Back to Top
lovely_man View Drop Down
Newbie
Newbie


Joined: 29 May 2003
Location: Jordan
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote lovely_man Quote  Post ReplyReply Direct Link To This Post Posted: 29 May 2003 at 1:58pm
Originally posted by Vinay Vinay wrote:

Got it sussed!

I have edited the registration page to remove some of the fields that I did not want. This also included the time offset and date format fields. Have created two hidden text fields for this info now.

Cheers

Hi, I've read this sent by you Vinay. i'm still facing the same problem. can you help me by telling me how you fixed it. i made some adjustment to the register page. but when i tried to get the old one, it didn't work too.

Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.