ERROR 2147217913/conversion char to datetime/out of range 1

[dobrowski]

The following proc is producing the runtime error 2147217913 - the conversion of char data type to a datetime data type resulted in an out of range datetime value.

if @LicenseIssueDate > convert(datetime,'11/30/' + convert(char(4),@LicenseYear))

Hardware: NT.40 sp6a server software: ms sql 7.0 sp2.

I scripted out a working copy of the whole database. Then went to another machine and ran the script, to create the database tables and proc's. This is the only problem that i ran into after i started using the newly created databse.

 

[tlbroadbent]

What is the value of @LicenseYear? Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[dobrowski]

@LicenseYear int,
@LicenseIssueDate datetime,


.Parameters("@LicenseYear&quot = CInt(Format(Now, "YYYY&quot)

.Parameters("@LicenseIssueDate&quot = Format(Now, "MM/DD/YYYY&quot

 

[dobrowski]

I checked the values of the parms

.Parameters("@LicenseYear&quot = 2001

.Parameters("@LicenseIssueDate&quot = 6/1/2001

 

[tlbroadbent]

Have you resolved the problem? I can't see anything syntactically wrong! Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot

 

[dobrowski]

No. I am thinking it is a machine error. NT error. We are reinstalling SQL on the machine now with sp1 and then sp2.

Any other ideas would be helpful.