how to get data in between two date

Hello,

You can use >= and <= which will return same day data, you are using between which will not consider fromdate and todate,

select * from save_master where date >= @fromdate AND date <= @todate

Another way try 

select * from save_master where date >= @fromdate AND date <= @todate

if not work this work 100%

select * from save_master where (CONVERT(DATE,date ) >= CONVERT(DATE, @StartDate) and CONVERT(DATE, date ) <= CONVERT(DATE, @EndDate))

1. DECLARE @monthfrom int=null,  
2. @yearfrom int=null,  
3. @monthto int=null,  
4. @yearto int=null,  
5. @firstdate DATE=null,  
6. @lastdate DATE=null  
7.   
8. SELECT @firstdate=DATEADD(month,@monthfrom-1,DATEADD(year,@yearfrom-1900,0)) /*Setting First Date using From Month & Year*/  
9. SELECT @lastdate= DATEADD(day,-1,DATEADD(month,@monthto,DATEADD(year,@yearto-1900,0)))/*Setting Last Date using From Month & Year*/  
10.   
11. SELECT * FROM tbl_Record  
12. WHERE (DATEADD(yy, Year - 1900, DATEADD(m, Month - 1, 1 - 1)) BETWEEN CONVERT(DATETIME, @firstdate, 102) AND  
13. CONVERT(DATETIME, @lastdate, 102))