Good afternoon All,
I am trying to calculate the incremental increase (in months) at each change of the CURRENT_TARGET_DT for a given ISSUE_ID with multiple occurances on different rows. Can anyone give me an idea? Basically, looking at the data below I would need to calculate the difference between 7/21/2012 and 7/21/2013, then calcuate it for 7/21/2013 and 3/14/2014. Any help would be appreciated.
[pre]ISSUE_ID CURRENT_TARGET_DT
IS-622316 7/21/2012
IS-622316 7/21/2013
IS-622316 3/14/2014[/pre]
thanks in advance for your time
I am trying to calculate the incremental increase (in months) at each change of the CURRENT_TARGET_DT for a given ISSUE_ID with multiple occurances on different rows. Can anyone give me an idea? Basically, looking at the data below I would need to calculate the difference between 7/21/2012 and 7/21/2013, then calcuate it for 7/21/2013 and 3/14/2014. Any help would be appreciated.
[pre]ISSUE_ID CURRENT_TARGET_DT
IS-622316 7/21/2012
IS-622316 7/21/2013
IS-622316 3/14/2014[/pre]
thanks in advance for your time