To find records between two dates.

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

2 Replies

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

Mayank Jani9y ago
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
0
Guest User9y ago
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.
0