I'm wanting all the inclusive dates that fall in the range of the dates specified. My first logic (startdate > ?vpstart and enddate < ?vpend) omitted results when either the start or end date fell outside the specified range.
So if a leave started on 01/01/2004 and ended 02/01/2004 I would not get the record if the report was run 01/15/2004 - 01/25/2004. I think I fixed it with the code below.
Thanks for your help!!! You are an incredible asset to the Foxpro community.
>>Sorry about that stupidity. Think I figured it out.
>>
>>
>>select * from leavetable where startdate <= ?vp_end and enddate >= ?vp_start
>>
>>
>>
>>Does that appear correct for getting all dates?
>>
>
>Do you want only records that start and end between specified dates or you want records that start or end between specified dates ?