I don't know if i am missing something. :hehe:

But we should be able to achieve desired result(Last 10 Days) via below

Select user,min(action)

from logtable

where action >=convert(varchar(11,getdate()-10,106)

group by User

Or if you...

Have we tried explicit conversion and see if it works?