I need some Tsequel Coding that will find some records between two dates so that I can do a Count. I need the coding where Between is used.
SELECT COUNT(dbo.LicenseFY10.LicType) AS TotalCount, dbo.luLicenseType.LicType, dbo.luLicenseType.LicDesc
FROM dbo.LicenseFY10 INNER JOIN
dbo.luLicenseType ON dbo.LicenseFY10.LicType = dbo.luLicenseType.LicType
WHERE (dbo.LicenseFY10.LicType IN ('010', '011')) AND (dbo.LicenseFY10.ExpirationDate < '09/30/2011')
GROUP BY dbo.luLicenseType.LicType, dbo.luLicenseType.LicDesc
This works but does not give me the real records between the two dates.
How can I re-write this to do the count correctly.
I need the count of Lictypes between, 10/01/2010 and 09/30.2011.