Re: error with calldate

Dale E. Reed Jr. ( (no email) )
Sun, 13 Apr 1997 23:16:41 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: David Khoury: "Re: CallsOnline and tempdb"
Next message: Philip Thomas: "External Service?"
Maybe in reply to: Mourad Dahoumane: "error with calldate"

Mourad Dahoumane wrote:
>
> Dale,
>
> 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.

> AND CallDate < '04/31/97'

April only has 30 days. :(

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |    http://www.emerald.iea.com

Previous message: David Khoury: "Re: CallsOnline and tempdb"
Next message: Philip Thomas: "External Service?"
Maybe in reply to: Mourad Dahoumane: "error with calldate"