Loading

filter between two dates using stored procedure?

Rahul Kumar

FilterDate between ISNULL(CONVERT(DATE,@FromDate),'2000-01-01') and

ISNULL(CONVERT(DATE,@ToDate),'3000-01-01'))

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Hey Rahul,

Please convert all date in same culure, Please check your filterDate column datatype conversion for both parameter and where clause column should be same.
CONVERT(DATE,FilterDate) between ISNULL(CONVERT(DATE,@FromDate),'2000-01-01') and
ISNULL(CONVERT(DATE,@ToDate),'3000-01-01'))
Please find below link to get specific way to display your date,
https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/
Rajeesh Menoth6y ago
Hi,Add your logic In the following reference : https://stackoverflow.com/questions/14953754/stored-procedure-which-count-records-between-two-dates