DateTimePicker not selecting Date correctly from RDLC report

Maina Abubakar

1y891C#

I have a column in my mysql dB called date_in as DATE using this format(2020-10-10), and I have my RDLC report which searches between date_in and populate the result. My problem is I have a datetiepicker1 and 2 which searches between date_in, I can only search using datetimepicker.value which gives this format 2020/10/10 07:40:40 so if I have to search to get this date 2020-10-20 I have to backdate it to 2020-10-19 due to the datetimepicker.value and when I changed to datetimepicker.Text it populate and error that it cannot convert string to system.datetime I am using C# windows form

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Maina Abubakar1y ago
Is not passing thesame things. Datetimepicker.value is passing this format 2020/10/10 07:10:40 while my DB format is 2020-10-10 when I use datetimepicker.Text it shows error of string not convertable to system.datetime because my RDLC report is expecting a date value
+1
Maya Chopra1y ago
Check if the DateTimePicker control is using the correct date format. If the format of the date in the DateTimePicker differs from what's expected by the RDLC report, it may not select or pass the date correctly.
+1