SQL Query Not givan relevent result

[dearhemantha]

I have a sql database I want to generate a report which is I am suplying date rage in there year is not taken for rane query is below

SELECT COUNT(*) AS Expr1
FROM WHIRE_Candidate
WHERE (UploadStatus = 1) AND (CONVERT(char(10), KeyedDate, 101) BETWEEN '06/01/2005' AND '09/30/2005') AND (UserId = '1')

hear i am getting 1000 count but if i change the query date range '08/01/1999' AND '09/30/2005'

count reduce why is that

thank you
hemantha

 

[xwb]

06/01/2005 is June 01, 2005
08/01/2005 is August 01, 2005

There is less data from August to September than from June to September.