Hi
I am using VB6 and an SQl database.
I have a sql statement where I want to select records that occur between two dates picked using the date picker, I have tried formatting the dates using format (date,ddmmyyyy) etc but have had no luck in making my sql work.
I am convinced that is is a formatting problem as if I pick a day that is 12 or below the statement works (incorrectly) but if I pick a day that is over 12 I get the error 'could not create an acceptable cursor'
I am using the where clause:
WHERE start_date BETWEEN dt_from AND dt_too
on the surface all the dates look in the same format (ddmmyyyy) but I have spent all day on this and don't know where to go next.
Any help would be gratefully accepted.
I am using VB6 and an SQl database.
I have a sql statement where I want to select records that occur between two dates picked using the date picker, I have tried formatting the dates using format (date,ddmmyyyy) etc but have had no luck in making my sql work.
I am convinced that is is a formatting problem as if I pick a day that is 12 or below the statement works (incorrectly) but if I pick a day that is over 12 I get the error 'could not create an acceptable cursor'
I am using the where clause:
WHERE start_date BETWEEN dt_from AND dt_too
on the surface all the dates look in the same format (ddmmyyyy) but I have spent all day on this and don't know where to go next.
Any help would be gratefully accepted.