To compute the no of month base on Key Figures
Appreciate if could help.
I would like to compute the remaining month left base on the depreciation start date given in the characteristic, ie depre start date: 01-May-2005 and current financial date 01-Apr-2006. LifeSpan: 10 Yrs.
Thus, the remaning life: 10*12 - (Month(01-Apr-2006) - Month(01-May-2005)).
For the (Month(01-Apr-2006) - Month(01-May-2005)), Any method can be directly get the month of the date provided and do our own formula in the Query designer?
Alternatively, if the 1st method is not possible, are we able to use VBA instead?
Your advise is very much appreciated.
Thank you in advance.