Get date by comparing in another date field

[prasad]

Hi,

I have 2 tables linked by unique id NRIC. One table has code and Joindate. The second table has Transactions Visit date.

I need to compare Transactions date to Joindate and check if Transactions date should be greater than the first date and lesser than the next join date. i have attached one sample, pls let us know how to achieve this. Thanks! in advance. Tks!

Prasad

[Taoufiq_Zarra]

can you give more details on how you join the two tables ?

[prasad]

Hi, by joining Nric field, i have attached the screen shot. Tks!

[Taoufiq_Zarra]

in the first line of the results file why 22/02/2005 became 22/02/2007
why there's more than one line of DB#

the result of a joint is not correct except if there is a logic behind it?

[prasad]

Yes Correct, the logic we need to check transaction date against Join dates, it should be in between the join dates ie, it should be lesser than the next join date and greater than the in between dates. same as the attached example. Tks! in advance. 

[prasad · Accepted solution]

Hi,  Thanks We got the solution using IntervalMatch. Tks!