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

VINAY KUMAR

9y1.1kVisual Basic .NET

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...................................

5 Replies

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

Asma Khalid9y ago
Accepted 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'))
+1
Rajeev Punhani9y ago
Hi Vinay,
Please find the below link.
https://www.codeproject.com/tips/355235/how-to-search-between-two-dates-and-get-all-record
+1
Amit Gupta9y ago
@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'
0
Catcher Wong9y ago
Hi ,

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

+1
Ramesh Palanivel9y ago
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
+1