I'd just got used to refering to date fields in Access....
I know that sql server should be able to automatically convert a string to a date to allow you to search for records by date. However, when I try to find a record with a particular date (previously taken from the database itself), it tells me that the result of the conversion is "out of range".
I've tried using CONVERT on both the search variable and the database field, and I've tried converting one/both dates to English and American formats. The database generally uses local (British) date formats: is it possible my asp engine doesn't? any tips?
I know that sql server should be able to automatically convert a string to a date to allow you to search for records by date. However, when I try to find a record with a particular date (previously taken from the database itself), it tells me that the result of the conversion is "out of range".
I've tried using CONVERT on both the search variable and the database field, and I've tried converting one/both dates to English and American formats. The database generally uses local (British) date formats: is it possible my asp engine doesn't? any tips?