How to filter between date in C# with sqlite crystal report

See more:

C#

SQLite

I work on project c# with SQL server and I changed the database in SQLite I faced a problem with between date filter in the crystal report
I try this code it shows the last item date only and sometimes not showing anything any help

What I have tried:

SQLiteConnection con = new SQLiteConnection("Data Source=HospitalDB.db;datetimeformat=currentCulture;version=3;");

DateTime from = DateTime.Parse(dateTimePicker1.Value.ToString());
DateTime to = DateTime.Parse(dateTimePicker2.Value.ToString());
SQLiteCommand cmd = new SQLiteCommand("select* from BillTbl where PDate>= '" + from + "' and PDate<= '" + to + "'", con);
SQLiteDataAdapter sd = new SQLiteDataAdapter(cmd);
DataSet s = new DataSet();
sd.Fill(s);
CrystalReport1 sr = new CrystalReport1();
sr.SetDataSource(s.Tables["Table"]);
crystalReportViewer1.ReportSource = sr;