>Hello
>
>A datetime field in SQL may be 'Oct 1,2005 04:00PM'
>
>But when selecting records for a range of dates from 'Oct 1,2005' to 'Oct 1,2005' , SQL Server assumes a default time of '12:00AM' so the transaction is not selected.
>
>A solution is to set the final search date to 'Oct 1,2005 11:59PM' but my question is : Is it possible to compare only the date portion and ignore the time portion ?
>
>Thanks
It'd take more to ignore time portion IMHO. Adjusting enddate is easier I think. ie:
dStart = {^2005/10/05}
dEnd = Dtot({^2005/10/05}+1)-1
SQLExec(m.lnHandle,;
'select * from myTable where myDateTime between ?m.dStart and ?m.dEnd','myCursor')
Cetin