How to compare two dates and get the result in months?

[nig3b]

Hi Bubblers!

I’m trying to get the number of months from a start date and the first day of the current month.

I can get it in number of days but can’t figure out how to find months.

Thanks in advance!

[mikeloc]

Hi there, @nig3b… you can divide the resulting number of days by 30 to get the number of months. Check out this post for an example…

Calculate years, weeks, days from two dates

Hi all, I need to calculate number of years, weeks and days from two dates. I am able to simply calculate the total number of days, but I can’t figure out how to narrow down from years to weeks to days. (for example 2 years, 25 weeks and 4 days). Thanks! Wouter

Hope this helps.

Best…
Mike

[nig3b]

Thanks @mikeloc
I was hoping there would be a build-in solution or a way to have an exact way. But yes the /30 works

Thanks