I need to retrieve some event types over a range of dates from one of our databases using **SQL Server Management studio**.

E.g.

```
104 Card printed    14/11/2015
205 Broken Attract Loop 15/11/2015
 56 Card printed    15/11/2015
245 Broken Attract Loop 16/11/2015

```

I'm trying to get to the dates for from 26/01 to 29/02 2016. 

I've asked a colleague who was maintaining the database, who has sent me this:

```
Select 
    count(e.eventstart),    
    convert(e.eventstart),      
    et.eventtype
From 
    tblevents e, tbleventtype et
Where 
    et.eventypeid = e.eventtypeid
    And et.eventtype in ('field1','field2')
Group by 
    convert (e.eventstart), et.eventtype

```

And something about separating out time and date as `eventstart` is recorded as follows: 2009-01-17 16:48:58.000.

I can't make head nor tail of it; I'm a complete SQL novice, and no more help seems to be forthcoming from the ex-database maintainer. 

Could some one please advise?

Thanks.