Skip to Content
0
Former Member
Oct 16, 2006 at 01:01 PM

Data between two dates

12 Views

Hi,

I have to display data between arrival date and departure date based on user input.

Ex-

Arrival date Depart Date

01.01.2005 06.01.2005

07.01.2005 10.01.2005

11.01.2005 12.01.2005

Requirement :

User will enter date : 01.01.2005 to 07.01.2005.

Now it should pick all the data between this range .

Output :

01.01.2005 06.01.2005

07.01.2005 10.01.2005

Both records lies between 01.01.2005 to 07.01.2005, so it should display 2 records.

Pls guide.

Thx in advance

Nilesh