Skip to Content
author's profile photo Former Member
Former Member

To compute the no of month base on Key Figures

Hi,

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 26, 2007 at 03:35 AM

    Start date and current data are dates, they are not months and if you subtract, you will get number of days not number of months. The closest you can do is you need to divide the value by 30 (average days of all months) which is a day and use the rounding of to get the months. Once you get the months then you can easily subtract that from 10*12 and come up to the remaining life.

    thanks.

    Wond

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.