Skip to Content
0
Former Member
Mar 08, 2009 at 09:50 AM

Select records with a specified date period

667 Views

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