TeamDesk Knowledge Base & Support

Home

FAQ

Forum

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