Skip to main content
M
MM_902332215-Moonstone
15-Moonstone
December 9, 2023
Solved

Calculate time difference between true/false timestamp

  • December 9, 2023
  • 1 reply
  • 1572 views

I have a requirement where I have to calculate the time difference between two instances of the PumpRunSignal property (Boolean), we need to determine the duration in minutes. The Pump Run Signal is a Boolean property that triggers an event data subscription and a service call when there is a change from true to false in the input from the PLC. We calculate the time difference by comparing the timestamps of index values 1 and 0 of the PumpRunSignal. However, there is a delay in loading data from Thingworx to InfluxDB when there is a false signal. To address this delay, we have implemented a 30-second Pause every time there is a false signal. While this pause logic seems effective, there is some uncertainty about its reliability, especially when dealing with multiple calculations for each Thing within Thingworx.

 

Thank you!

Best answer by Velkumar

Hi @MM_9023322 

 

I can see there is a one-minute time difference between the actual and logged values. This could be due to Math.floor method.

 

Instead of Math.floor use Math.round method. 

 

For your reference:

Velkumar_0-1703046336580.png

 

If you want a more accurate time. You need to get the decimal value from the minute and multiply it with 60 which will give you exact seconds. And you can add seconds to your minutes.

 

/VR

1 reply

V
19-Tanzanite
Velkumar19-Tanzanite
19-Tanzanite
December 11, 2023

Hi @MM_9023322 

 

You can use subscription input EventData - NewValue Time and OldValue Time to get the time difference

 

Velkumar_0-1702276540245.png

 

Sample Code in Subscription

 

if (!eventData.newValue.value) // If new value is false
{
	// Calculate time 
	me.timeDifference = dateDifference(eventData.newValue.time, eventData.oldValue.time); // Returns milliseconds
}

 

 

/VR

 

 

 

    M
    MM_902332215-MoonstoneAuthor
    15-Moonstone
    December 19, 2023

    Hi @Velkumar,

     

    Whenever the signal triggers from true to false, the time difference is calculated. But the false trigger time and the time stored in the Database are not the same, so there is some conflict in the time difference calculations.

     

    Below is the code:

    MM_9023322_0-1702985815616.png

     

     

    The time difference is calculated using the above code in Thingworx and manually for the PumpRunSignal property. The highlighted in Red are mismatching.

     

    MM_9023322_1-1702985815622.png

     

    MM_9023322_2-1702985815625.png

     

     

    MM_9023322_3-1702985815627.png

     

     

     

     

    V
    19-Tanzanite
    Velkumar19-TanzaniteAnswer
    19-Tanzanite
    December 20, 2023

    Hi @MM_9023322 

     

    I can see there is a one-minute time difference between the actual and logged values. This could be due to Math.floor method.

     

    Instead of Math.floor use Math.round method. 

     

    For your reference:

    Velkumar_0-1703046336580.png

     

    If you want a more accurate time. You need to get the decimal value from the minute and multiply it with 60 which will give you exact seconds. And you can add seconds to your minutes.

     

    /VR

    Terms & ConditionsAccessibility statement