Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Phara
Contributor III

Calculate the amount of months between two dates

Hello,

I'd like to know  what is the right formula to calculate the amount of months between two dates?

I had found this formula: = Interval(date(today())- date([EA begin date ]),'MM')

but it doesn't work because all I see in my data is ''00'' for each lign.

Can someone help me please?

naomi_0-1686876220462.png

 

Thanks!

Labels (1)
1 Reply
BrunPierre
Partner - Master

=((Year(Today(2))*12)+Month(Today(2))) - (((Year([EA begin date ])*12)+Month([EA begin date ])))