How to find Result between two dates

Question

0.00/5 (No votes)

See more:

I want to fill grid by selecting two dates.
data should between two selected dates. i have little idea

WHERE CreatedDate between @date1 AND @date2

Tell me how can i get data.

Posted 22-Nov-12 1:25am

Yasir Farooq

Add a Solution

Comments

Anele Ngqandu 22-Nov-12 7:28am

you mean you want a sql statement?

Yasir Farooq 22-Nov-12 7:34am

yes.
just storedprocedur

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hari Chandra Prasad Ravuri · Answer 1 · 2012-11-22T02:11:00

hi i Think This Code helps you

SELECT * FROM TABLE

WHERE DATE BETWEEN
Convert(varchar,CreatedOn,103)=CONVERT(varchar,ISNULL('01/02/2012',CreatedOn),103)
AND Convert(varchar,CreatedOn,103)=CONVERT(varchar,ISNULL('05/05/2012',CreatedOn),103)

"103" stands BRITISH/FRENCH FORMAT

for more search this link http://www.sql-server-helper.com/tips/date-formats.aspx[^]

pallavi Praharaj · Answer 2 · 2012-11-22T02:03:00

if i understood your question correctly then you may use this to get the answer

SQL

DECLARE @date1 datetime,@date2 datetime
SET @date1='2012-07-20'
SET @date2='2012-07-25'
Select ColName from TableName WHERE ColName between @date1 AND @date2

you can give the date range in @date1 and in @ date2 from your textbox or anywhere else

Anele Ngqandu · Answer 3 · 2012-11-22T02:01:00

Solution 1

Hi please try this sql statement

C#

SELECT *
FROM TABLE 
WHERE CreateDate 
BETWEEN '01/01/2009' AND '01/31/2009'

Vote if it helps....

Posted 22-Nov-12 2:01am

Anele Ngqandu

Comments

Yasir Farooq 22-Nov-12 8:03am

Can i pass parameter on date like?
BETWEEN @dateFrom AND @dateTo

Anele Ngqandu 22-Nov-12 8:13am

Yes you can...

How to find Result between two dates

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0