To find records between two dates.

Question

Dear All Greetings of the day. I am working on an application named Hotel Management and it is about to keep all the records from guest check-in to check-out. I am using VS2008 and MS Access as database. while running a report of guest checkin i found some problem. the report runs but does not show the correct result. there are two datetimepickers one command button and one data grid view. >the guests checked in between 01/07/2017 and 18/07/2017 >when i select dates between 01/07/2017 and 09/07/2017 it shows all the records beyond 09/07/2017. >when i select dates between 01/07/2017 and 05/07/2017 it shows messagebox 'No Record Found'. my query is... OleDbDataAdapter DateRecord = new OleDbDataAdapter(Select * From Guests Where CheckIn Between # + dtpFrom.Value.Date.ToShortDateString() + # AND # + dtpTo.Value.Date.ToShortDateString() + # myconn); if i put dtpFrom.Value.Date.ToShortDateString() instead of dtpTo.Value.Date.ToShortDateString() it shows no record for any criteria. Kindly help to let me know where i am mistaking. Please see the screen shots for more clarification if required. Thank You Mayank Jani

Mayank Jani · Answer

Dear Mr.Jothish Kumar thank you for your reply... that would be a static query but i have written the query in an application and the user will select the dates from date time picker. so it can be anything. please see the screen shots attached 'Report.zip'. you'll get proper idea what i am trying to say. Thanks Mayank Jani

Jothish Kumar · Answer

Hi SELECT * from (Table name) where From_date BETWEEN ( '2013-01-03'  '2013-01-09' ) OR To_date BETWEEN ( '2013-01-03'  '2013-01-09' ) OR From_date '2013-01-03' AND To_date >= '2013-01-09' Try the above queries which will give you the result.