data fetching comparing dates.

there are 2 fields in the table

Beginging and End date

for every employee there r two or more rows.

In my selection screen i m selecting month and year.i want to fetch only that row for a employee which comes in date range.

for example

selection screen

month 05

year 2009

beg end

04/2008 09/2008

10/2008 09/2009

so it shud select the second row.

thanks.

Edited by: aks on Aug 6, 2009 5:25 AM