Number of months between two dates

Hi Fabian,

So AFAIK, i don't think there's a direct way to do this. But using a little logic it's pretty simple. Firstly use the fn!year() on both dates and compare the years difference, if the difference is zero you can proceed with using fn!month function on both dates and get the difference between the two months. If the year difference wasn't zero then u can add those many numbers of months to the above result. So if the year diffference was 1, you add 12 months and so on.

Hi Fabian,

So AFAIK, i don't think there's a direct way to do this. But using a little logic it's pretty simple. Firstly use the fn!year() on both dates and compare the years difference, if the difference is zero you can proceed with using fn!month function on both dates and get the difference between the two months. If the year difference wasn't zero then u can add those many numbers of months to the above result. So if the year diffference was 1, you add 12 months and so on.