More Duration Options (Especially Years/Months)

Suggestion Box
1

I’d love to see Duration with the option of years, with the option to have a full year or a year and a month.

8 Likes
2

absolutely

I tried something like this, but didn’t work
RoundDown((Today()-thisRow.[start date])/365,0)+ " years, " (Today()-thisRow.[start date])/365 - RoundDown((Today()-thisRow.[start date])/365,0) +" months"

3

Hi,
unfortunately so far there is not an enhanced duration of bigger time parts.

I provided a rough calculation that could be useful for many use-cases:

Please: keep in mind that it’s an approximation (e.g. not leap-years compliant).

Let me know if it helps.
Cheers

4

I would find this feature useful as well. I would rather group it as following:

  • Days (already available)
  • Weeks
  • Months
  • Quarters
  • Years

This would be awesome for long term project management and roadmap estimations.

1 Like
5

Hi @Federico_Stefanato

There is an inaccuracy in your document if you put exactly 1 year:

268 chrome

6

273 chrome

1 Like
7

I’d love to see this, as well as monthly & yearly automations.

8

if(Floor((today() - thisRow.Start) / 365 - (today() - if(IsBlank(thisRow.End),today()+1,thisRow.End))/ 365)>0,Concatenate(Floor((today() - thisRow.Start) / 365 - (today() - if(IsBlank(thisRow.End),today()+1,thisRow.End))/ 365)," yr “,Concatenate(mod(round((today() - thisRow.Start) / 365 * 12, 0)-round((today() - if(IsBlank(thisRow.End),today()+1,thisRow.End)) / 365 * 12, 0),12), " mo”)),Concatenate(mod(round((today() - thisRow.Start) / 365 * 12, 0)-round((today() - if(IsBlank(thisRow.End),today()+1,thisRow.End)) / 365 * 12, 0),12), " mo"))

9

Are there any better options to make this work in the years since it was first asked?