Calculate months between two dates

NUH_ro1ia8

Hello, 

I created an Automation Rule to calculate the total months between start and end date fields and then store the result in a Customfield. 

How can I round the number of months ? because I got a wrong result, 1 month is missing. 

 This is my smart value:

{{issue.end date.diff(issue.start date).months.abs}}

Thank you,

Nouha

Bill Sheboy

Hi @NUH 

For a question like this for diff() not working as expected, please provide the example date values, the result returned, and what you expected to happen.  That will provide context for the community to offer better suggestions.

 

Until we see those...

The date / time function diff() only returns integer values in the units of measure selected (e.g., months).  Depending on the units, it may use floor, ceiling, or rounding adjustments.

To take control of the difference and explicitly round to the desired precision, you could do this:

• perform the diff in a smaller unit of measure,
• divide the value with a number for the conversion between the two values,
• wrap that with the round() function, and 
• wrap that inside of a math expression.

For example, to do this for rounded days from seconds to 2 decimal places, where 86400 is the number of seconds in a 24h day:

{{#=}} round( {{issue.dateA.diff(issue.dateB).seconds}} / 86400, 2) {{/}}

 

The challenge for your scenario is your units are months, and those have a variable number of days per month.  And so seeing the specific date values you are using may indicate what is happening.

Kind regards,
Bill