cancel
Showing results for 
Search instead for 
Did you mean: 

Data between two dates

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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!