cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

Unable to get the difference between two dates and times

Tomellache2B
14-Alexandrite

Unable to get the difference between two dates and times

Hi, community,

 

I have been spinning my wheels with getting the differenthe ce between two dates and time.

The aim is to find the duration between the time a device is turned off and when that device is turned on.

 

I have two different services that output a datetime value. One service outputs the time the device is turned on and the second service outputs the time the device is switched off.

I then created a third service that calculates the difference between the two times.

 

Below is what I wrote in my third service:

var date1 = parseDate(onTimes_Input, " dd-MMM-YYYY HH:mm");
var date2 = parseDate(offTimes_Input, " dd-MMM-YYYY HH:mm");
let result= dateDifference(onTimes, offTimes);

 

when I execute the above, I get the following error: 

Error executing service getDuration. Message :: Invalid format: "1661387400000" - See Script Error Log for more details.

 

 

Does anyone know what this could mean?

Best Regards

Jay_nisaa

1 ACCEPTED SOLUTION

Accepted Solutions

 

Try below code to get a difference between 2 datetime values. If parsing not required, then directly use here.

 

result = Math.abs(date1 - date2)/(1000 * 60);  //In Minutes

 

 

 

View solution in original post

3 REPLIES 3

Hi @Tomellache2B,

 

Did you try running the dateDifference service directly with onTimes_Input and offTimes_Input?  If the result of the services that provides these values is DATETIME the value is already in milliseconds and does not need to be parsed.

 

Thanks,

 

Travis

 

Try below code to get a difference between 2 datetime values. If parsing not required, then directly use here.

 

result = Math.abs(date1 - date2)/(1000 * 60);  //In Minutes

 

 

 

thank you very much. This was helpful.

 

1. Additionally, I did a few things I want to share.

To convert the minutes to hours:

      var x = Math.abs(date1 - date2)/(1000 * 60); 

      var inHours = x/60;

 

2. To get the time difference to display in hours and minutes (e.g., 12 hours 30 minutes):

         var hours = parseInt(x/60); ///get the absolute value of the hours without minutes (inHours).

         var minutes = Math.floor((inHours- hours)*60); ///get the absolute value of the minutes.

         

         let result = hours + "h"+minutes ///concatenate the hours and minute.

 

Best Regards

Top Tags