Web Wiz Support and Community Forums : CDate problem in some posts

Web Wiz Support and Community Forums : CDate problem in some posts https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 05 Apr 2026 10:11:26 +0000 Sun, 01 May 2005 16:28:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=13374 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[CDate problem in some posts : Ok my problem is: Microsoft...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post82232.html#82232 Author: TomBrien
Subject: 13374
Posted: 01 May 2005 at 4:28pm

Ok my problem is:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'CDate'

/forum4/common.asp, line 448

I have tried editting the common.asp files and clearing cookies no luck. Any one have any ideas?

Tom

]]> Sun, 01 May 2005 16:28:09 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post82232.html#82232 <![CDATA[CDate problem in some posts : rdfonseca wrote: My error...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post75432.html#75432 Author: sfd19
Subject: 13374
Posted: 03 February 2005 at 8:19pm

rdfonseca wrote:

My error is:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'CDate'
/website/forum/default.asp, line 154

Clear your cookies. You have stored a cookie with a different date format on your computer than the one the server is using.

]]> Thu, 03 Feb 2005 20:19:38 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post75432.html#75432 <![CDATA[CDate problem in some posts : It should solve all problems withforums...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post75002.html#75002 Author: sfd19
Subject: 13374
Posted: 28 January 2005 at 7:44pm

It should solve all problems with forums that were moved from one region to another.]]> Fri, 28 Jan 2005 19:44:03 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post75002.html#75002 <![CDATA[CDate problem in some posts : sfd19 wrote:We had the same...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74991.html#74991 Author: b_w_t
Subject: 13374
Posted: 28 January 2005 at 4:22pm

sfd19 wrote:

We had the same problem after switching from an American server to a German server and then back to an American. It was annoying

Right before this line in /functions/functions_format_post.asp

If isNumeric(dtmEditedDate) Then dtmEditedDate = CDate(dtmEditedDate) Else dtmEditedDate = 0

add a new line.

When your server is using "." in the date format (eg German servers) then add

dtmEditedDate = Replace(dtmEditedDate,",",".")

or when your server is using "," in the date format (eg American servers) then add

dtmEditedDate = Replace(dtmEditedDate,".",",")

When you are not sure what format your current server is using then check for a message in your database that has been edited with the current server settings and see if that server is using "," or "." in the number of the edited date. Then apply the fitting code line from above.

That should help.

This solved my problem too after I had re-located my website to a european server.

]]> Fri, 28 Jan 2005 16:22:47 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74991.html#74991 <![CDATA[CDate problem in some posts : My error is: Error Type:Microsoft...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74861.html#74861 Author: rdfonseca
Subject: 13374
Posted: 27 January 2005 at 8:12am

My error is:

Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'CDate'
/website/forum/default.asp, line 154

]]> Thu, 27 Jan 2005 08:12:19 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74861.html#74861 <![CDATA[CDate problem in some posts : martionline wrote: in common.asp...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74425.html#74425 Author: sfd19
Subject: 13374
Posted: 20 January 2005 at 8:06pm

martionline wrote:

in common.asp line 56

'Set the date time format to your own if you are getting a CDATE error
'Session.LCID = 1033 ==>make this Session.LCID = 1033 erase single quota

That does not help when you have already stored edited dates in different formats in your database (by changing the host, for example). Then you either have to run a query against the database that re-formats the edited date in all posts or you can use my code above.

The Session.LCID only applies to new posts. Not to already stored ones.

]]> Thu, 20 Jan 2005 20:06:31 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74425.html#74425 <![CDATA[CDate problem in some posts : in common.asp line 56 'Set...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74420.html#74420 Author: martionline
Subject: 13374
Posted: 20 January 2005 at 6:17pm

in common.asp line 56

'Set the date time format to your own if you are getting a CDATE error
'Session.LCID = 1033 ==>make this Session.LCID = 1033 erase single quota

]]> Thu, 20 Jan 2005 18:17:30 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74420.html#74420 <![CDATA[CDate problem in some posts : We had the same problem after...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74058.html#74058 Author: sfd19
Subject: 13374
Posted: 17 January 2005 at 5:03am

We had the same problem after switching from an American server to a German server and then back to an American. It was annoying

Right before this line in /functions/functions_format_post.asp

If isNumeric(dtmEditedDate) Then dtmEditedDate = CDate(dtmEditedDate) Else dtmEditedDate = 0

add a new line.

When your server is using "." in the date format (eg German servers) then add

dtmEditedDate = Replace(dtmEditedDate,",",".")

or when your server is using "," in the date format (eg American servers) then add

dtmEditedDate = Replace(dtmEditedDate,".",",")

That should help.

Edited by sfd19 - 17 January 2005 at 11:32am]]> Mon, 17 Jan 2005 05:03:16 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74058.html#74058 <![CDATA[CDate problem in some posts : The problem seems to be occuring...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74033.html#74033 Author: jurgen
Subject: 13374
Posted: 16 January 2005 at 4:41pm

The problem seems to be occuring on the old posts which have been edited.

Changing the configuration doesn't solve that because the editor's message is already in the database.
There is some problem configuring the date/time written with the old version of WWF.

Has anyone a solution for this problem?

]]> Sun, 16 Jan 2005 16:41:37 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74033.html#74033 <![CDATA[CDate problem in some posts : jurgen wrote:No, that didn't...]]> https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74001.html#74001 Author: jurgen
Subject: 13374
Posted: 16 January 2005 at 11:29am

jurgen wrote:

No, that didn't do it.

As I said, changing this configuration didn't solve the problem.
Why?

]]> Sun, 16 Jan 2005 11:29:10 +0000 https://forums.webwiz.net/cdate-problem-in-some-posts_topic13374_post74001.html#74001