C# Programming
08-13-2011, 03:12 AM
I want to filter for "date " filed for record selection formula :
ds = new DataSet(); con = new OleDbConnection(conString); con.Open(); da = new OleDbDataAdapter(strSelectionTable, con); da.Fill(ds, "PersonelDate"); OurReport.cryRpt reportPrint = new Bank_Project.OurReport.cryRpt(); reportPrint.SetDataSource(ds); reportPrint.RecordSelectionFormula = "{PersonelDate.DatePaying} Between '" + getDateFromFileBank.ToString()+ "'AND'" + getDateToFileBank + "'"; and i got this error !
the remaining text does not appear to be part of formula
thanks for any HELP !
ds = new DataSet(); con = new OleDbConnection(conString); con.Open(); da = new OleDbDataAdapter(strSelectionTable, con); da.Fill(ds, "PersonelDate"); OurReport.cryRpt reportPrint = new Bank_Project.OurReport.cryRpt(); reportPrint.SetDataSource(ds); reportPrint.RecordSelectionFormula = "{PersonelDate.DatePaying} Between '" + getDateFromFileBank.ToString()+ "'AND'" + getDateToFileBank + "'"; and i got this error !
the remaining text does not appear to be part of formula
thanks for any HELP !