Here’s a question that came out from one of our training consultants…
I am wondering if we can display the duration of a contract within months.
I’v added a custom field with this formula subtract(number($end_date),number($start_date))
But it calculates only the days e.g.
1.1.2013 – 1.1.2014 = 0
1.1.2013 – 2.2.2014 = 1
I also tried it with the daysUntil formula but this formula also calculates rubbish.
Does anyone know if or how we are able to solve such a requirement?
Playing around with Sugar Logic more, we found the formula that doesn’t calculate rubbish😉. Try this for size…
Thanks to my fellow Sugas for the nice tip!