How to subtract two time variables to get seconds

Help
1

Can I use a DATE/TIME block to subtract two times, the results being the number of seconds between the times? How?

I can do this with a FUNCTION node:

var lstDate = new Date(payload.working.LastStartTime)
var nowFDate = new Date(payload.time);
payload.currentCycleTime = (nowFDate - lstDate) / 1000; // Convert to seconds

Where this is the payload:

image
image548×545 11.7 KB

I’ve tried it with a DATE/TIME block but I only see the number of seconds in the time of day sent through.

3

Hey @Bryan_Chase,

Yes you can find the difference between two time stamps using the Date/Time node. You want to use the logical function Diff that is included in this nodes configuration options in the Operation drop down.

This function returns the difference in milliseconds between the source date and the date provided.

Set your Path of Date to Compare to working.LastStartTime payload path.

Let us know if this solves your issue.

Thanks,
@Aidan_Zebertavage

5

Diff produces units of milliseconds. That works, but how would I get seconds?

6

@Bryan_Chase,

I would use the Math node and divide the milliseconds by 1000 to perform the conversion to seconds.

Thanks,
@Aidan_Zebertavage