Searching by date with SQL Server

[LucyP]

I've been trying to retrieve files from a SQL server database (using ASP) having searched on a date field (generated by the database using GetDate). I know that SQL server should be able to convert a string to a date field with no problems, but I always get the error:

resulting date out of range.

I've tried various CONVERT procedures, as I think the problem may have something to do with my sql server using British date formats: I've tried converting the comparison string and the date field itself, British and American formats, but with no luck. Can anyone help?

 

[Antzz]

Can you post your sql statement here and also the date format?

Thanks

 

[yuben]

You can also try to change the default date format of SQL server from the enterprise manager :

Rightclick on the server, select properties.
Select server settings. Change the default language for user to British english (dd/mm/yy).

SQL installs with 'English' as the default language which I assume is american (mm/dd/yy)

 

[LucyP]

Thanks: it was the "English" setting in SQL server.