I want to return records in crystal for  June 2010 & 2011 and I only want the records that have an owner group of Service Desk.

This is my code...

{HPD_Help_Desk.Owner_Group} = "Service Desk" and
{HPD_Help_Desk.Last_Resolved_Date} in DateTime (2010, 06, 01, 00, 00, 00) to DateTime (2010, 06, 30, 23, 59, 59) or {HPD_Help_Desk.Last_Resolved_Date} in DateTime (2011, 06, 01, 00, 00, 00) to DateTime (2011, 06, 30, 23, 59, 59)

 

However when the records are returned i am getting all Owner Groups and not just Service Desk.

 

I assume it is todo with the date query? I would really appreciate some help with this to understand what I am doing wrong?

 

Thanks

Steve