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