Compare 2 sets of data according to a Start and an End date column

[salsawarren]

Hi,

This is my first post on this forum so i apologise if I am not posting in exactly the right place, but I think my problem can only be solved with VBA script so I am trying here.

In my attachment I am trying to identify rows within Table 2 that do not fit in with Table 1. Hopefully my attachment is clear. For example in Table 2, Row 16 has a Start Date of 17.11.2010 and an End Date of 13.11.2011 for ID number 151. This record has to be shown as "OK" because it fits into the date range of Row 103 of Table 1 i.e. Table 1 Row 103 has a Start Date of 01.01.2010 and an End Date of 28.02.2013 for ID 15. In other words the Start Date of Table 2 Row 16 is GE the Start date of Table 1 Row 103, and the End Date of Table 2 Row 16 is LE the End Date of the same Row 103 of Table 1, therefore this reocrd is OK.

Row 14 of Table 2 needs to be shown as "NOT OK" because it has a Start Date of 12.01.2013 and an End Date of 31.03.2013 for ID 15 and this doesn't fit any date range of any Row in Table 1 for ID 15.

Any help greatly appreciated.

[nilem]

Hi salsawarren,
maybe so

Please Login or Register  to view this content.

[salsawarren]

Thank you for your quick answer. That worked perfectly.... thank you so much. ))))))