I new in this forum, but i hope someone expert can help me!

SELECT CustName,address, DateEnter
FROM SalesStatusReport_view
WHERE DateEnter >= '01/06/05' AND DateEnter <= ' 15/06/05'
ORDER BY DateEnter DESC

But the code doesn't work properly, it only return the record within the day range , i.e 01 -15 all come out even the mth and yr is incorrect. So can anyone help me to solve this problem????
Thank you very much!!!

Looks like your date format is incorrect. What date format are you using mm/dd/yy or mm/dd/yy?

How about below? (cosidering today's date). Also , try to post exact error message you were receiving.

SELECT CustName,address, DateEnter
FROM SalesStatusReport_view
WHERE DateEnter >= DATEADD(dd,-21,GETDATE()) AND DateEnter <= DATEADD(dd,-6,GETDATE())
ORDER BY DateEnter DESC

You have two options. The first one is exactly as you have shown:

SELECT CustName,address, DateEnter
FROM SalesStatusReport_view
WHERE DateEnter >= '01/06/05' AND DateEnter <= '15/06/05'
ORDER BY DateEnter DESC

The second is to use the BETWEEN operator as follows:

SELECT CustName,address, DateEnter
FROM SalesStatusReport_view
WHERE DateEnter BETWEEN '01/06/05' AND '15/06/05'
ORDER BY DateEnter DESC

As someone else suggested, you need to make sure your date format is correct. Is SQL Server set as dd/mm/yyyy or mm/dd/yyyy? You need to check this.

Scott

Pleaser CHECK THE Date Format
As dd/mm/yyyy or the other

Thanks for everyone!
YES...The problem is because of the date format is different from the one i use in the sql statement.