Crystal Reports - Get data between two dates

Question

1.00/5 (1 vote)

See more:

Dear Experts..

I am new in crystal Report development. I want to know that how to get the data from between two dates. I am having Two Textboxes for from date and To date in a FrmDate(Form). and put one button for clicke event. if i am give the two different date into two texbox and then click that button my report showing the data between that dates only. kindly help to me..
DB is sqlserver2005
Thanks in Advance.
Sreeni

Posted 25-Aug-14 1:12am

sreenivashan

Updated 5-Sep-19 20:45pm

Add a Solution

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)

RAHUL(10217975) · Answer 1 · 2014-08-25T01:19:00

Solution 1

Select * from
TableName t
WHERE CONVERT(Date,t.Fromdate,10) >= CONVERT(Date,@FromDate,10)
and
CONVERT(Date,t.ToDate,10) <= CONVERT(Date,@ToDate,10)

Please accept this solution if its fulfill your needs

Posted 25-Aug-14 1:19am

RAHUL(10217975)

Comments

sreenivashan 25-Aug-14 7:28am

Hi Rahul.. This is my Question.
I am new in crystal Report development. I want to know that how to get the data from between two dates. I am having Two Textboxes for from date and To date in a FrmDate(Form). and put one button for clicke event. if i am give the two different date into two texbox and then click that button my report showing the data between that dates only. kindly help to me..
DB is sqlserver2005
Thanks in Advance.
Sreeni

RAHUL(10217975) 25-Aug-14 9:26am

Wat's the problem? Try What I have written

OriginalGriff · Answer 2 · 2014-08-25T01:23:00

Solution 2

First off, don't use text boxes: use a Calendar control or a DateTimePicker instead. Textboxes mean that users enter what they want, which may not be a valid date (or even close to a valid date). The otehr controls only let them select "proper" dates, and save you having to validate them.

Then, just use an SQL SELECT:

SQL

SELECT * FROM MyTable WHERE MyDateColumn BETWEEN @StartDate AND @EndDate

Fill in the dates via a parametrised query, and pass the DateTime objects from the controls directly.

Posted 25-Aug-14 1:23am

OriginalGriff

Comments

sreenivashan 25-Aug-14 7:29am

Hi.. ok i am not use text box for dates. and use the datepicker, but my question is : I am new in crystal Report development. I want to know that how to get the data from between two dates. I am having Two Textboxes for from date and To date in a FrmDate(Form). and put one button for clicke event. if i am give the two different date into two texbox and then click that button my report showing the data between that dates only. kindly help to me..
DB is sqlserver2005
Thanks in Advance.
Sreeni

OriginalGriff 25-Aug-14 8:27am

Read what I said?

Member 14581006 · Answer 3 · 2019-09-05T20:46:00

Solution 3

select * from MyTable where DATE BETWEEN '" + Convert.ToDateTime(TXT_FROM_DATE.Text).ToString("MMM/dd/yyyy") + "' AND '" + Convert.ToDateTime(TXT_TO_DATE.Text).ToString("MMM/dd/yyyy") + "'

Posted 5-Sep-19 20:46pm

Member 14581006

Comments

CHill60 6-Sep-19 3:40am

Reasons for my downvote:
1 - this is no different to Solution 2 posted 5 years ago
2 - You are using Convert.ToDateTime which will throw an exception if the text is not in the correct format
3 - Your code is vulnerable to SQL Injection attack - never concatenate strings to create SQL statements - especially if they use data direct from user input.