Hi Guys, can help me with the following scenerio below. I need to derive the number of days for DAY_LAST_TRNS field. If there is a transaction taken place, the calculation of day_last trns field will be MTH_END - TRNS_DTE. However, if there was a refund to net off the previous transaction, we will not consider it as a transaction record. Therefore, we will take the last transaction as the latest record. Please advice what is the code to derive for DAY_LAST_TRNS. MTH END TRNS_DTE NAME TRNF_AMT DAY_LAST_TRNS (MTH_END-TRNS_DTE) 31May2001 04May2001 ABC 10000.000000 27 31Jan2012 17Jan2012 ABC 3564.000000 14 31Jan2013 30Jan2013 ABC 3564.000000 1 31Dec2013 31Dec2013 ABC 4000.000000 0 31Jan2015 19Jan2015 ABC 4000.000000 12 29Feb2016 16Feb2016 ABC 4000.000000 13 28Feb2017 15Feb2017 ABC 4000.000000 13 28Feb2018 03Feb2018 ABC 2000.000000 25 31Jul2018 27Jul2018 ABC 2000.000000 4 31Jan2019 25Jan2019 ABC 2000.000000 6 30Sep2019 02Sep2019 ABC 5300.000000 28 30Sep2019 02Sep2019 ABC -5300.000000 248 Days = 30 Sept - 25 Jan
... View more