Hi, I have following data, where I need to set Termed_Date as effective_date - 1, if there is a new ndc_fee. how do I do it. NDC NDC_FEE TERMED_DATE effective_date 00002140701 $1.8326 02/08/2018 00002140701 $1.7970 04/01/2018 00002719001 $0.0000 01/24/2018 02/08/2018 00002759701 $20.8000 02/08/2018 00003083050 $1.3924 02/08/2018 00003085222 $410.6738 02/08/2018 00003085222 $430.4023 04/01/2018 Highlighted are the rows for same NDC there is a New_Fee with new Effective_Date. I would like to see the result as follow; NDC NDC_FEE TERMED_DATE effective_date 00002140701 $1.8326 03/31/2018 02/08/2018 00002140701 $1.7970 04/01/2018 00002719001 $0.0000 01/24/2018 02/08/2018 00002759701 $20.8000 02/08/2018 00003083050 $1.3924 02/08/2018 00003085222 $410.6738 03/31/2018 02/08/2018 00003085222 $430.4023 04/01/2018
... View more