Last months date appears as not valid

This in my code to select various clicks from various date ranges

SELECT     MIN(A.hitDate) AS minDate, D.AffiliateName, B.ProdType, COUNT(DISTINCT A.ipAddress) AS TOTAL
FROM         ArchiveApplyTracking A LEFT OUTER JOIN
                      Configuration.dbo.Affiliates D ON A.affiliateID = D.AffiliateID LEFT OUTER JOIN
                      ArchiveCampaignIncoming C ON A.campaignID = C.ID LEFT OUTER JOIN
                      Configuration.dbo.ProductType B ON A.productTypeID = B.ProdNo
WHERE     (A.hitDate >= @FromDate) AND (A.hitDate < @ToDate)) AND (A.ipAddress NOT IN
                          (SELECT     ipAddress
                            FROM          [Tracking].[dbo].ipTracking)) AND (B.ProdType IN (@ProductType)) AND (A.deal = 1) AND (D.AffiliateName IN (@AffiliateName))
GROUP BY D.AffiliateName, B.ProdType
ORDER BY D.AffiliateName

In RS2005, my users can then select the date ranges, and view the clicks in that period. It works great,............. until someome selects a date from any other month than the current, where the error shows

"The value provided for the report parameter 'FromDate' is not valid for its type. (rsReportParameterTypeMismatch)"

Why is it fine for this month and not any other

Any idea's

Answer this question

Last months date appears as not valid

Last months date appears as not valid

Answer this question