Comparing Current Row To Next Row Using SSIS Script Component

I'm trying to determine proper end date for measuring the effectiveness of my client's email campaigns. For each email address that received the campaign, I would like to determine a measurement end date. This date should be the lesser of 7 days from the Sent date or the date of the last email offer. This way, I prevent double-counting the revenue associated with each email campaign. Here's an example of what I'd like to see for each unique Sent Date and Email Address:



Sent Date Email Address Measurement End Date <<<< This is what I'm trying to derive with a script

2/22/2007 test@test.com 2/29/2007 <<<< 7 days from Sent Date

2/18/2007 test@test.com 2/22/2007 <<<< 4 days from Sent date due to the 2/22/2007 email

1/20/2007 test@test.com 1/27/2007 <<<< 7 days from Sent Date

etc.



If the input data stream is sorted by Email Address and descending Sent Date, then I need to be able to compare the Sent Date on the current record to the Sent Date on the next record (until the Email Address changes and then the process starts over).



I'm open to any solutions as this has really stumped me for awhile.