No need to involve a time portion

where dTrnDate >= @dIniDate and dTrnDate < @dFinDate + 1

>We are doing something similar directly on SQL Server:
>

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

>