2 Replies Latest reply on Feb 11, 2011 10:19 AM by JustinLevens

    Relationships based off date range

    JustinLevens

      Title

      Relationships based off date range

      Post

      I'm attempting a create a relationship based off a date range.  According to the description of the relationship operators I would assume this is possible.  Table A consists of an assessment schedule for participants in a study and Table B consists of their survey data.  In table A I created two variables that essentially create the window for that assessment based off the scheduled date of completion.  Because the participant won't always complete the survey on the date it's scheduled there needs to be window.  The window dates are hard coded into the table using the scrpt to create the assessment schedule.  What I would like to happen is the survey data table the match the assessment schedule record based off the window dates.  So if the survey was completed on 2/13/2011 for participant 5555, the assessment window for participant 5555 for assessment 3 is 1/20/2011 to 2/22/2011, so because the survey was completed on 2/13/2011 for participant 5555 these records would be related.  However, it doesn't appear to be pulling the records.  Is this even possible and I'm understanding the relationship operators wrong?  Thanks.

      Screen_shot_2011-02-11_at_12.05.01_PM.png