Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks!
=((Year(Today(2))*12)+Month(Today(2))) - (((Year([EA begin date ])*12)+Month([EA begin date ])))