asp.net web application search between two dates ...

Question

ASP.NET WEB APPLICATION i want search between two dates ex:01/12/2016 to 01/02/2017 iwant display only between 3 months data .... iam using below code only check dates not months........ select * from tablename where date between '01-12-2016' AND '01/02/2017' plz help me...................................

Asma Khalid · Answer

your issue here is that you are comparing dates valus exactly with the designated columns and I am assuming that your table date column is of datetime type. This means you need to discard time part from both your target column and your from and to dates i.e. select * from tablename where DATEADD(dd,0,DATEDIFF(dd,0, date )) between DATEADD(dd,0,DATEDIFF(dd,0, '01-12-2016' )) AND DATEADD(dd,0,DATEDIFF(dd,0, '01-02-2017' ))

Rajeev Punhani · Answer

Hi Vinay, Please find the below link. https://www.codeproject.com/tips/355235/how-to-search-between-two-dates-and-get-all-record

Amit Gupta · Answer

@Vinay It has always been observed for many times that the problem is occuring with only the date formats Always use the universal format 'yyyy-MM-dd' format instead using 'MM-dd-yyyy'. You can change its format whichever suits the clients. try searching like this select * from tablename where date between '2016-12-01' and '2017-02-01'

Catcher Wong · Answer

Hi , I can not understand you question clearly ! Do you mean that?

Ramesh Palanivel · Answer

HI Vinay, Try your code first in your DB, if it is working fine , check whether the DB and system format both are same or not. try this URL, It may help you http://stackoverflow.com/questions/14353434/selecting-data-between-2-dates http://stackoverflow.com/questions/16447877/c-sharp-between-two-dates-search http://stackoverflow.com/questions/35272405/how-to-search-between-two-dates-in-c-sharp-with-ms-access http://www.c-sharpcorner.com/forums/search-between-two-dates