Select records with a specified date period

Hi all,

In my selection screen, i allow user to specify any date period, e.g., 08.01.2004 to 23.04.2008.

And, the db records may be like the below table, in such case, the three records should be selected with the above selection criteria.

My question is that how could I correctly select the records from DB that fall within the specified time period?

Many Thanks !

ID | BEGDA | ENDDA

1 | 09.09.2005 | 11.11.2006

2 | 12.11.2006 | 07.07.2008

3 | 01.01.2002 | 12.12.2007