Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculate Duration in years
Message
 
À
22/03/1999 13:20:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00200532
Message ID:
00200623
Vues:
9
>Actually, I should have been more specific. What I need is a function like:
>
>?GetTimeSpan({09/15/2000},{03/16/1999})
>
>Returns
>
>1.4673454
>
>Where I am getting caught up I guess is determining the number of days in a year.
>
>I know I am wrong so far from comparing my results with the textbook results for the same range. For example, my method (#days/365.25) gives
>
>9.5711 years
>
>and the book shows
>
>9.5816 years
>
>trouble is, I am fairly sure the 'book' uses a method called 30/360, I just don't know what that method is.
>
>Thanks for your input.

I think you should find the number of full years (9 in this case) and then work with the partial year separately. So use the year year(date())-1 and use the original month and day (and handle Feb.29 if you need to).

30/360 sounds like for partial years they use a 360 day year and for partial months they use a 30 day month. This would probably be used depending on whether a rate is compounded annually or monthly. I would look into the exact definition/methodology.

Joe
Joseph C. Kempel
Systems Analyst/Programmer
JNC
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform