AnsweredAssumed Answered

Calculating months from days

Question asked by TylerNelson on Dec 3, 2014
Latest reply on Dec 4, 2014 by philmodjunk


Calculating months from days


Hi! I have a question that I imagine will be super easy for the wizards on this forum.

I have a calculation field that uses a basic calculation to get the number of days in a period:

DaysLeftInPeriod = PeriodEndDate - PeriodStartDate

I'd like to deduce the months left in the period using a more precise calculation than the one I'm currently using:

Case (Not IsEmpty (PeriodEndDate) ; Round (DaysLeftInPeriod / 30 ; 1 ) ; 0 )

I know that this gives me inconsistent months, since some months have 31 days. Is there a function or calculation that calculates months from days more accurately?