AnsweredAssumed Answered

Join tables that a between a variable value

Question asked by MylesGartland on Nov 19, 2011
Latest reply on Nov 19, 2011 by MylesGartland

Title

Join tables that a between a variable value

Post

Please help a moderate user. I can do basic joins with little problem- but having trouble with this twist. FP 11 Pro on Mac.

Need to join two tables (say A and B).

Table A has a ID, Beginning Date, Ending Date (like 444, 07012011, 07302011)

Table B also has an ID, and a service date (like 444, 07152011).

I need to join records IF

ID = ID (not a problem)

AND

IF service date in B falls between beginning date and ending date in A.

It is this second one that gets me. I have only done = joins, never a "falls between" join.

Any help?

Outcomes