FN-FORUM:

date posted 8th August 2004 12:11

Hi,

I am getting


Microsoft OLE DB Provider for SQL Server error '80040e07'
The conversion of a char data type to a datetime data type resulted in an
out-of-range datetime value

when I use convert(datetime in my sql statement

I have tried putting the following infront of the sql statemt


SET LANGUAGE = British
GO


But I then get

Microsoft VBScript runtime error '800a01a8'
Object required: 'British'


Help - what am I going wrong. I have also tried English aswell


Thanks
Pam