Prior repair tech within specific no. of days

[xarapre7]

I have list of SN (serial numbers) and TECH (Technician) with COMPLETED DATE and Within 90 Day Flag. I need a script that will show the previous repair's TECH as long as it's within 90 days (based on the Within 90 Days flag).  Can you please help? 

SN	Completed Date	Tech	Within 90 Days	Previous Tech w/in 90 Days	Comments
123	01/01/16	Smith, Brad	N	Blank	No previous repair
123	02/01/16	Lee, John	Y	Smith, Brad	There's a previous repair w/in 90 days
123	03/01/16	Yi, Oscar	Y	Lee, John	There's a previous repair w/in 90 days
234	01/01/16	Dole, Edward	N	Blank	No previous repair
234	03/01/16	Reed, Lee-Anne	Y	Dole, Edward	There's a previous repair w/in 90 days
345	01/01/16	Ti, Luan	N	Blank	No previous repair
345	02/01/16	Dean, Tyron	Y	Ti, Luan	There's a previous repair w/in 90 days
345	02/15/16	Akran, James	Y	Dean, Tyron	There's a previous repair w/in 90 days
345	06/08/16	Ferran, Joseph	N	Blank	This should be blank because this didn't fall within 90 days from previous repair

[sinanozdemir · Accepted solution]

Hi,

Here is the script that does it:

I am also attaching the qvw.

Thanks

[xarapre7]

Exactly what i need. Thank you very much for the help!

[sinanozdemir]

No problem.