Calculate months difference between two date fields

[Elena Pomana]

Hello,

I have a task to calculate the number of months between two date fields.

(Price validity end date – Change date)

I tried to solve it with the code below, but I don't think that's the best approach.

var changeDate = new GlideDateTime(current.u_change_date).getNumericValue(); //get the value of change date field in milliseconds

var endDate = new GlideDateTime(current.u_price_validity_end_date).getNumericValue(); //get the value of change date field in milliseconds

var finalMilliseconds = endDate - changeDate; //result is in milliseconds
var finalSeconds = finalMilliseconds/1000; // transform in seconds;
var finalMonths = finalSeconds/2629800; //transform in months;
var finalDate = finalMonths.toFixed(2);

I have doubts that this is the correct answer, some months have 30 days, other 31 and February 28/29.

Will it work better with substract() method?! Any ideas?

Thank you,

Elena

[Allen Andreas · Accepted solution]

Hi,

If you get a moment, check out this thread for a similar requirement: https://community.servicenow.com/community?id=community_question&sys_id=e57f3ea9db58dbc01dcaf3231f96...

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Elena Pomana]

Hello,

Thank you for the thread! It helped! 🙂

Have a nice one,

Elena