How to calculate total months between a Start date and End date?

[Community Alums]

Hi,

I am trying to calculate the Current Financial Years total months present between Start Date and End Date.

Case 1:

Start Date = 01/01/2022

End Date = 12/31/2024

Current FY months = 12 (i.e. Current year is 2023 so 12 months in 2023)

Case 2:

Start Date = 01/01/2022

End Date = 31/05/2023

Current FY months = 5 (i.e. Current year is 2023 only upto 5th month so its 5 months in 2023)

How do I calculate this using scripting?

Thanks in advance!!!!

[Basheer · Accepted solution]

Hi @Community Alums ,

Here you go

var months = 12;
var monthDiff= 0;

var startDate= new GlideDate();
startDate.setValue(current.start_date);
var gdtStart= new GlideDateTime(startDate);
var monthsStart=gdtStart.getMonthLocalTime();
var yearStart=gdtStart.getYearLocalTime();

var endDate= new GlideDate();
endDate.setValue(current.end_date);
var gdtEnd= new GlideDateTime(endDate);
var monthsEnd=gdtEnd.getMonthLocalTime();
var yearEnd=gdtEnd.getYearLocalTime();

if(yearStart != yearEnd){
monthDiff=(12-monthsStart)+(monthsEnd-1)+(yearEnd-yearStart-1)*12;
}
else{
monthDiff=monthsEnd-monthsStart-1;
}

//monthDiff gives us the month difference

[Community Alums]

But @Basheer this solution doesn't calculate the months in the current Year. It is supposed to return the no of months which is against the current Financial Year.

[Community Alums]

Thanks @Basheer