select cardno

,CAST(datetime1 AS DATE)

, MIN(cast(datetime1 AS time)) AS MINdatetime1

, MAX(Cast(datetime1 AS time)) AS maxdatetime1

from view1

GROUP BY cardno, CAST(datetime1 AS DATE)

Give that a try.

J