24 months should be two years but two years is 26 months

  • 2
  • Problem
  • Updated 4 years ago

I can see how this happens, months have been standardised.

I set the Start date to 24/09/2014 and the Due date to 23/09/2016 on a topic.

Duration: 523 workdays, 104 weeks or 26 months!

Entering a Duration of 24 months gives a due date of 26/07/2014.

Perhaps a more complex calculation should be performed to match the calendar month.  What do you think?

I was using this to track a bi-annual domain name renewal.

Photo of Andrew Wilcox

Andrew Wilcox, Champion

  • 1033 Posts
  • 177 Reply Likes

Posted 4 years ago

  • 2
Photo of Colin Horner

Colin Horner

  • 130 Posts
  • 18 Reply Likes
Hi Andrew
Maybe this is MJ's own calendar for annual license renewals?  Start date 18.09.2014, 12 mon, Due date 19.08.2014.  Just tell MM there's 52 weeks and you'll beat their system

Many thanks for pointing this out
Regards
Colin
Photo of Colin Horner

Colin Horner

  • 130 Posts
  • 18 Reply Likes
Apologies, my calendar's worse than theirs!  Due Date 10.08.2015
Colin
Photo of Nick Duffill

Nick Duffill, Champion

  • 512 Posts
  • 170 Reply Likes
This arises because a month is always 4 weeks for the purposes of calculating durations. When setting durations, the workaround is to use anything except months. You could try using 365 days instead, then you would only need to fix it every four years :)
Photo of Andrew Wilcox

Andrew Wilcox, Champion

  • 1033 Posts
  • 177 Reply Likes

That assumes you work weekends and public holidays. 365 days is 24/09/2014 to 16/02/2016.

Perhaps there should be another unit "everyday"?

Photo of Nick Duffill

Nick Duffill, Champion

  • 512 Posts
  • 170 Reply Likes
Yes, or a unit of "years" could work too.