Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

DATETIME DIFF - Rounding up between months

Topic Labels: Formulas
1347 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_Comerford
5 - Automation Enthusiast
5 - Automation Enthusiast

I’ve seen one or two topics touching on this, hoping to see if there is a workaround here. Using DATETIME DIFF appears to be rounding down the resulting unit by default. For example, calculating the number of months between 1/1/2015 and 12/31/2015 results in “11.0” with no possible means to round up to the more accurate “12” due to the result being rounded down. Is there a possible workaround for this that is capable of producing a value (maybe “11.9”?) that can then be used in conjunction with ROUNDUP to round up to the nearest whole number?

1 Reply 1

An imprecise way to do it would be: DATETIME_DIFF({Date 2}, {Date 1}, "days")/30

That results in decimal value, which you could round anyway you’d like.