Wondering if anyone can help as i'm really confused. I want to run two dynamic queries in the same format for half an hour time slots to output all records in the database where the start time is between:

12.00pm and 12.30pm.and

12.30pm and 13.00pm.

So I have a record in my database where the estimated_start_time is 11:45pm and estimated_end_time is 12:45pm

Now if I run the query I have written for between 12.00pm and 12.30pm a result is returned: