Data between two dates

[Former Member]

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

[Former Member]

Hi,

Create variable on Arrival and Departure date and restrict you charcteristic with this variables.

Regards,

San!

Message was edited by: San!

Message was edited by: San!