AnsweredAssumed Answered

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

Question asked by Kaps_1 on Sep 22, 2015
Latest reply on Sep 28, 2015 by 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

Attachments

Outcomes