Thank you Cetin,

We are doing something similar directly on SQL Server:

select *  from Transactions 
where dTrnDate >= @dIniDate 
and dTrnDate <= @dFinDate+0.9999  
order by dTrnDate

This expression: @dFinDate+0.9999 produces a date like:
'09/01/2005 11:59PM'


Thanks




>>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