error with calldate

Mourad Dahoumane ( )
Sun, 13 Apr 1997 17:47:19 +0200


I was using this statement to get how many hours a user logged in during
the month (timon cold fusion template). It was working fine until I had
this error :

[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of CHAR to
SMALLDATETIME resulted in a SMALLDATETIME value out of range.

even if I use sqlquery directly I get the same response. can you help me
where to look to solve the problem. My server is configured for US date
and time settings.

original query is :
SELECT CallDate, UserName, FramedAddress, (AcctSessionTime/60) + 1 as
CallTime, Location
FROM Calls, Servers
WHERE NASIdentifier=IPAddress
AND UserName='#User.UserName#'
AND AcctStatusType=2
AND CallDate >= '04/01/97'
AND CallDate < '04/31/97'

thank you.

Mourad Dahoumane