Hi,
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