Ooops, posted before my first cup of coffee <g> ... Victor's suggestion was better. =)
~~Bonnie
>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
>>