Jim,

Are we talking SQL Server here or something else? A suggestion (for SQL Server anyway):

I'm assuming that this is a datetime column? If so, first, your date should be in quotes. Secondly, you probably need to take the time into account too. So, you may want something like this instead:

and (end_time >= '01/05/04 00:00:00'
 or  end_time <= '01/05/04 11:59:59'

~~Bonnie


>Below is a SQL statement I am running. The query returns 0 records, but it should return 1 record. The problem is with the end_time portion of the where clause, though I don't know how to fix it.
>
>Please help
>
>

>SELECT dc_id, taskdtl_id, userid, start_time, end_time, total_time,
>   billable, opcode_id
>FROM data_collection
>WHERE taskdtl_id = 240
>and userid = 1
>and end_time = 01/05/04
>