Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ntn104
Posting Yak Master
175 Posts |
 Posted - 2013-05-15 : 07:38:05
|
| Hello everyone,Please help me to figure out how to fix my error message for "Type mismatch: '[string: "-0-0"]'", and it point to below statement:where a.dt_in between '" & SQLDate(rsReport("Creation_Date")) & "' and '" & SQLDate(DateAdd("d",1095, SQLDate(rsReport("Creation_date")))) & "'Thanks, |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-05-15 : 19:20:20
|
| You'll need to echo (response.write) the query so you can see it and figure out what's wrong.And the values of your variables.I'd guess your SQLDate(rsReport("Creation_date")) function is returning "-0-0" and the DateAdd() function is choking on that. |
 |
|
|
ntn104
Posting Yak Master
175 Posts |
Posted - 2013-05-16 : 11:12:14
|
There is a blank date in CREATION_DATE field, that was why it caused the problem I just added another sql statement to indicate where creation_date is null, then it clears the problem,Thanks,quote:
Originally posted by russell
You'll need to echo (response.write) the query so you can see it and figure out what's wrong.And the values of your variables.I'd guess your SQLDate(rsReport("Creation_date")) function is returning "-0-0" and the DateAdd() function is choking on that.
|
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-05-16 : 15:32:45
|
You're welcome. Glad you got it worked out.  |
|
|
|
|
|
|
Type mismatch: '[string: "-0-0"]'