I have an input table with the columns PAYOUT_DT (numeric, date9) and REQ_MAT_DURATION (numeric, 2.0). It's connected to an Extract transformation with a column using this expression: intnx('year', PAYOUT_DT, REQ_MAT_DURATION, 'same') An input row has these values: PAYOUT_DT=24MAR2012 REQ_MAT_DURATION=2 Based on this I would expect the output value to be 24MAR2014, but it's 24MAR2013. Where's the logic in this? :smileyshocked: It works as intended for most other rows, but no all. Some output values are one year off, like above. What might cause the discrepancies?
... View more