
Contributor III
2023-06-15
08:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Thanks!
460 Views
1 Reply

Partner - Master
2023-06-16
02:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=((Year(Today(2))*12)+Month(Today(2))) - (((Year([EA begin date ])*12)+Month([EA begin date ])))
439 Views
