>My brain is not working well today so I'm going to ask for some elementry help.
>
>I have attendence in a table with start dates and end dates of when an employee is on leave.
>
>I want to write a query (SQL Server backend) to retrieve all the records that fall between those two specified dates.
>
>Started with logic like: startdate >= ?vp_start and enddate < = ?vp_end but that doesn't return all the results it should.
>
>Simple I know... but it's been a rough day!
>
It should work as long as dates (datetimes) in SQL Server are stored w/o time portion. Otherwise change it to
vp_end = vp_end + 1
startdate >= ?vp_start and enddate < ?vp_end
--sb--