14 Replies Latest reply on Sep 28, 2015 8:23 AM by Kaps_1

    Extend found set  - Find all meetings for jobs having a meeting between two dates

    Kaps_1

      Hello,

       

      I have two tables Meetings and Jobs containing details of all meetings for all jobs. I need to find all the meetings for all the jobs that have a meeting between two given dates say 27/09/2015 and 30/09/2015

       

      Job Number
      Meeting Date
      Include YES/NO
      Reason
      38928/09/2015YesDate falls between given period on this job
      38927/09/2015YesDate falls between given period on this job
      389 30/09/2015YesDate falls between given period on this job
      38920/09/2015YesThere is at least one meeting between the given dates on this job
      35123/09/2015NoThere are no meetings between the given dates on this job
      35101/10/2015NoThere are no meetings between the given dates on this job
      35327/09/2015YesDate falls between given date on job
      35422/04/2015YesThere is at least one meeting between the given dates on this job
      35427/09/2015YesDate falls between given period on this job

       

      I have included my code below - I think it is somethimng to do with my extended found script step - but i can't see what I am doing wrong. Any thoughts ? Thanks

      Kaps