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,