Getting only DATE

I want to select and group by only the date part of the datetime(SQL Server) field. I want to see whether the employee is working for the 7th consecutive day. So I am seeing, each one day of the previous 6 days are having atleast one record. Can anybody please reply me, how to do it?

You could use our DatePart operator in the select, but also having to have the group by currently means you will have to create a custom load method and either use a stored procedure or text mode for your query. An alternate workaround we have used previously is to use the .Between() on the dates.