i am using vb.net windows application with ms access.
in my application i am generating report based on two date comparision.
in my databse that date field has date dataype.
in my report parameter i define that parameter as date type also.
but when i assign that parameter to my report datetime picker control like this :
Dim parameters(1) As ReportParameter
parameters(0) = New ReportParameter("customer", cmbname.Text)
parameters(1) = New ReportParameter("fromdate", dtpfrom.Value)
so it will creata a blank report the reason is "dtpfrom.value" is pass value as string and compare with databse date field but in databse it will find date field with date type so it will not compare or match with it so it will not convert string to date. i already tried cdate, convert.todate, .tostring("mm/dd/yyyy") but no one work.
so please anyone tell me how to do this..please its urgent if any one have idea then tell me soon,
Thank you so much