jjgirl
November 9th, 2009, 08:22 PM
I wrote a report using th ebelow formula which specifies dates to only be returned that occur in the month of October 2009. However, dates are also being returned from October 2008 as well. The code looks correct, can anyone tell whey it's returning dates from October 2008?
{crystal_SERVICE_Performed.SvcDate} in "10/01/2009" to "10/31/2009" and
({crystal_COMPANY.CompanyTableID} = 37996 OR
{crystal_COMPANY.ParentCompanyID} = 37996 OR
{crystal_COMPANY.RootCompany} = 37996)
{crystal_SERVICE_Performed.SvcDate} in "10/01/2009" to "10/31/2009" and
({crystal_COMPANY.CompanyTableID} = 37996 OR
{crystal_COMPANY.ParentCompanyID} = 37996 OR
{crystal_COMPANY.RootCompany} = 37996)