Hi,
I have the source column: Total_Life in Months and I would like to translate to Number of Years field and Remaining Months field.
Ex: Total_Life = 40 Months
Number of Years= 40/12=3.34 out of this I want only 3 (yrs)
Remaining Months=.34*12=4 Months approximately.
Basically I need to avoid decimals while getting year part and I need to consider the value after decimals for Months.
Could you help me with what function we may use in Datastage.
Thanks
Jana
Transalate Total Months to number of Yrs and months
Moderators: chulett, rschirm, roy