Calculate the amount of days between two dates

[chrisreidr]

Hey everyone, I am relatively new and am trying to determine how I can subtract two dates so that I ultimately end up with the number of days between the inputed value (date) and the current date.

I am returning the date values and current date appropriately but can't seem to figure out how to find the number of days between the two dates. Below are the dateDifference variables I tried using with no success.

What else can I try to calculate the value of days between the dateEntered and currentDate variables?

var gr = new GlideRecord('team_members');

    gr.query();

    while(gr.next()) {

        var dateEntered = gr.getValue('stage_date');

        var gdt = new GlideDateTime();

        var currentDate = gdt.getLocalDate();

        /*

          var dateDifference = Number(dateEntered) - Number(currentDate);

          var dateDifference = dateEntered.getNumericValue() - currentDate.getNumericValue();

          var dateDifference = GlideDateTime().subtract(dateEntered, currentDate);

          var dateDifference = GlideDateTime().subtract(dateEntered.displayValue(), currentDate.displayValue());

         */

        gs.info(dateDifference);

    }

[Claude DAmico · Accepted solution]

This may entirely have to do with date and time formatting. Try something like what I have below.

//Strings must be converted to date/time format for getNumericValue()
//Dates must also be converted to have a time value
/*
var enteredDate = new GlideDateTime(gr.getValue('stage_date') + " 00:00:00"); //Assuming field is a string value in the format "01/23/2023"
var enteredDate = new GlideDateTime(gr.getValue('stage_date')); //Assuming field is a date only field
*/

var enteredDateValue = enteredDate.getNumericValue(); //This returns in milliseconds

//Getting the local date/time was done correctly
var gdt = new GlideDateTime();
var currDate = gdt.getLocalDate();

var dateDiff = enteredDateValue - currDate; //Still in milliseconds here
var daysDiff = dateDiff / 24 / 60 / 60 / 1000; //Convert to days. Use Math.abs(dateDiff) to avoid negative values if needed.

[Mubashira]

Yes! this solution works

[chaitanyaya]

Thanks. It was helpful

[mia45]

To calculate the number of days between two dates, you need to convert both dates into a common format, like milliseconds, and then subtract one from the other. Afterward, divide the result by the number of milliseconds in a day (86,400,000) to get the difference in days. For an easy-to-use solution, you can try using an Online Date Counter to quickly calculate the days between two dates. In your case, try using the getNumericValue() method to get the dates in numeric form (milliseconds), subtract them, and then convert that result into days. This will give you the exact number of days between the entered date and the current date.