SQLBill,

The convert function will truncate the time part and give the output in the format 'mm/dd/yy' (for 101).

Then why wouldn't the query

SELECT * FROM tblprojects WHERE insertedDate >= CONVERT(smalldatetime, '01/01/2003', 101) AND insertedDate <= CONVERT(smalldatetime, '04/30/2003',101)

include '04/30/03'??

Cindy