Something like this?

select
CID,
convert(char(8), tmstamp, 112) as 'Day',
max(tmstamp) as 'Last Logout'
from
dbo.SomeTable
group by
CID,
convert(char(8), tmstamp, 112)
order by
'CID', 'Day'

Simon