6 Replies Latest reply on Nov 19, 2011 2:43 PM by MylesGartland

    Join tables that a between a variable value

    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?