show crystal report of particuler date

See more:

C#2.0

C#

hey frnds,
i am doing one project in that i have problem in doing crystal report.i use the datepicker for taking date.
i m usineg the selection formula is:---

DateTime date = DateTime.Today;

DateTime tomorrow = DateTime.Now.AddDays(1);

this.crystalReportViewer2.ReportSource = rpt;
               this.crystalReportViewer2.SelectionFormula = "{Booking.Arrival_Date} in datetime('" + date.ToShortDateString() + "') to datetime('" + tomorrow  .ToShortDateString  () + "')";
               this.crystalReportViewer2.Refresh();
               crystalReportViewer2.Refresh();

its work for currnet date not for old date.
so plz say solution with selection formula.


THANKS,