In my software i have used dateTimePicker control, its format is long,when user insert details its data stored in database.
now here is my problem, i want to sort that data between two dates but how i dont know, i have alreaddy inserted lots of data with long format of dateTimePicker.
i want to sort data between two dates, i have tried this query but it is not running.
select * from Table where Date>='dateTimePicker1.Text' and Date <='dateTimePicker.Text'
but this is not working, can any one tell me how can i sort data between two dates, i know in short format i can sort it but i have alreaddy inserted lots of data with long format.