سلام از between استفاده کنید

select * from tbl where date between '1399/09/01' and '1399/09/30'