Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Duration format : years and months
To have the option for:
YEARS and MONTHS
In the format list for duration formulas.
For years to be displayed as 1.5 years
or better, 1 year 6 months.
ID
694
Category
TeamDesk
Author

gerardo garcia
Date Created
11/27/2013 1:42:36 PM
Date Updated
2/21/2014 3:17:50 AM
Status
Not Planned
Score
10
Promoted By
gerardo garcia
Comments
Kirill Bondar  Staff  11/27/2013 2:35:13 PM
Unfortunately, duration can not be expressed in months in years precisely: 366 days is 1.0 year if the year is leap, and 1.03 years if it is not. The same is with months: 28 days is 1.0 month if it is February of non-leap year, and slightly less than 1 for all the other cases.

Given two dates, you can basically reach you goal with the following formula:

Format(YearsBetween([To], [From], "0")) & " years " & Format(Rem(MonthsBetween([To], [From]),12), "0") & " months"


gerardo garcia 11/27/2013 3:09:33 PM
I Understand now that duration is intended for exact calculations and that is why month and year option is not available and if needed should be performed in differente fórmula. Ok.
Thanks Kirill.
Arnold Hakobyan 2/21/2014 3:17:50 AM
Can you add Week? If it doesn't vary, then maybe it is possible, isn't it?
Feedback
 
Back to Search Results