Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - 30 December 1899 as date...tried all!
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

30 December 1899 as date...tried all!
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
jackbros View Drop Down
Newbie
Newbie


Joined: 10 February 2005
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jackbros Quote  Post ReplyReply Direct Link To This Post Topic: 30 December 1899 as date...tried all!
    Posted: 01 March 2005 at 5:38am
Hi there,
 
I have an irritating problem.
 
If I log in, every post and member and indeed every type of date appears as '30 December 1899' 
 
If I don't log in, they are as normal.
 
I have changed the Session.LCID in common.asp to 2057 and removed the '
 
What can I do? And why does this problem seem to be so frequent amongst these forums. I have never encountered it before on a personal development based. Can you not alter the code to get rid of this problem?
 
Many thanks
 
Jack
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: 01 March 2005 at 6:15am
The 30 December 1899 is the date at which VB Script starts at for dates.

If your forum is returning this date then for some reason the date is not being feed into the forum correctly and so VB Script is defaulting to it's start date.

Things that could course this problem is if all the dates and locales on the server, set in the servers control panel, are not all set to the same locale.

If this is the case it could mean that dates in Access and dates for the web server are saved differently cousing this problem.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jackbros View Drop Down
Newbie
Newbie


Joined: 10 February 2005
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jackbros Quote  Post ReplyReply Direct Link To This Post Posted: 01 March 2005 at 6:17am
The strangest thing is, when I look in the database, the correct dates appear. (SQL)
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: 01 March 2005 at 6:50am
Dates are not generally stored in a database in the way they look, often behind the scenes they are stored as decimal numbers, giving a decimal date in secouhds from 30 December 1899.

If the date formats are not compatible then you can get problems like you mention.

Just becuase the date format in the database looks correct, if doesn't mean it is correct.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jackbros View Drop Down
Newbie
Newbie


Joined: 10 February 2005
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jackbros Quote  Post ReplyReply Direct Link To This Post Posted: 01 March 2005 at 6:55am
My fault! I had adjusted the registration page and consequently deleted the date field.
 
As you are here! I desparately need a way of validation extra fields I have put in.
 
I have tried putting script in CheckForm() but it then ignores everything else. :( I have tried everything. what can I do?
 
I want two email boxes and validate both are the same,
 
and also check that another extra drop down is completed. How do I tie this all into the CheckForm() script so that it pops ups with the usual blurb if incomplete?
 
Many thanks. Great Forum!!
 
Jack
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: 01 March 2005 at 7:23am
If none of the javascript validation is running then it suggests that you have made an error in what you have put in.

Download and install Firefox as your browser as it has a really good built in javascript debugger that can help track down what the problem is with your javascript.

http://www.mozilla.org/
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
jackbros View Drop Down
Newbie
Newbie


Joined: 10 February 2005
Status: Offline
Points: 17 		Post Options Post Options   Thanks (0) Thanks(0)   Quote jackbros Quote  Post ReplyReply Direct Link To This Post Posted: 01 March 2005 at 7:35am
All sorted, somehow second time seemed to work!
 
Too many late nights!
 
Thanks again! Great Forum


Edited by jackbros - 01 March 2005 at 8:38am
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.