Error DTMDATE in Version 7.6
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14222
Printed Date: 15 April 2026 at 7:38pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Error DTMDATE in Version 7.6
Posted By: RAVALON
Subject: Error DTMDATE in Version 7.6
Date Posted: 13 March 2005 at 7:38am
|
Hello....i use WebWizForum from 1 year...
yesterday i received a message like this
Type Mismatch: 'dtmdate'
in file functions_date_time_format.asp
I look for incriminated string and i obtain this code
-------------------------------------------------
If strTimeOffSet = "+" Then
dtmTempDate = DateAdd("h", + intTimeOffSet, dtmDate) ElseIf strTimeOffSet = "-" Then dtmTempDate = DateAdd("h", - intTimeOffSet, dtmDate) End If -------------------------------------------------
I can see in the posts where i obtain error, dtmdate is empty, so it cannot use for a date type...
How can i resolve this problem ?
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 13 March 2005 at 7:59am
|
If you get this error then it means that for some reason a date is not being passed to the function. You haven't said on what page and where the error is coming up, so it's hard to tell the exact problem. If the date is coming from the database, then it could be that you have a corrupted database, if you are using access. Running a compact and repair on the database may resolve the issue. If the date is coming from another source such as a cookie, then you may have a corrupted cookie, which is not uncommon with Internet Explorer, and you may need to clean out your cookie cache. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: RAVALON
Date Posted: 13 March 2005 at 8:15am
|
yeah....i resolved problem...
The errorr appear because of different LCID value in common.asp and in my personal configuration file in my site....
in common asp i have LCID=1033 for UK server and in my configuration file i have 1044 for italian server....i modify the values for corresponding to italiana where needed and to uk where needed...
Sorry...and thanks !
|
Posted By: RAVALON
Date Posted: 05 October 2005 at 10:38am
|
no....problem not resolved....
i obtain again this error....the page is Forum_Posts.asp
i put a response.write information, and i obtain, for the case with error (not in all thread i have error) data value passed as numeric value, .....some similar to this for example....
38553.7342013889
...or empty value....so no date passed.....or passed as a number...
i don't know how...
someone could help me ?
 |
Posted By: WebWiz-Bruce
Date Posted: 05 October 2005 at 11:17am
|
Becuase of problesm with verious date formats the date is strored as a number. VBScript stores dates as a number in secounds since Jan 1st 1899, or some point around that time. The number you see is the number of secounds since that date, by using the CDATE function VBScript is able to convert the number back into a date and time. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: RAVALON
Date Posted: 05 October 2005 at 12:15pm
|
if i try to use CDATE function i have message "Type Mismatch :Cdate" i don't understand...
 |
Posted By: WebWiz-Bruce
Date Posted: 05 October 2005 at 12:18pm
|
This then means that the date is not being correctly save and/or read back in. This is usually to do with locale issues on the server and without access to the server the best way to correct this is to change the LCID number in the common.asp file. I am working on a more perminent robust solution for future versions that will use an alterntive method to get around these problems with servers not having the locale settings set properly on them. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: RAVALON
Date Posted: 05 October 2005 at 12:22pm
| ok Borg....and for the moment how could i resolve ? what do you think is best solution ? |
Posted By: RAVALON
Date Posted: 09 October 2005 at 8:27am
|
....
i have this problem converting forum to MySQL....
as you know, MySQL want date in format yyyy/mm/dd,
How have i to set LCID variable ? as American format or italian format ?
....i specify i have the problem of type mismatch vith date in different page trying to change LCID var to american or italian....
|