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

SOLVED
Granite

## Need help with date functionality.

Hi All,

I have 1 date time variables as below.

var Date1 = 2020-06-03 18:02:13.700 //last connection property of a thing in date time datatype

How can I get the difference between current time and Date1 in format of days,hours,minutes, seconds (2 days, 7 hours, 8 minutes, 39 seconds)

Thanks and Regards,

Bhanu.

1 ACCEPTED SOLUTION

Accepted Solutions

## Re: Need help with date functionality.

Something like this may help:

var seconds=~~((milliseconds/1000)%60);
var minutes=~~((milliseconds/(1000*60))%60);
var hours=~~((milliseconds/(1000*60*60))%24);
var days=~~((milliseconds/(1000*60*60*24))%365);
var years=~~((milliseconds/(1000*60*60*24*365))%1000);
return (years?years+'y ':'')+(days?days+'d ':'')+(hours?hours+'h ':'')+(minutes?minutes+'m ':'')+(seconds?seconds+'s ':'');
}
Tags (1)
2 REPLIES 2

## Re: Need help with date functionality.

Something like this may help:

var seconds=~~((milliseconds/1000)%60);
var minutes=~~((milliseconds/(1000*60))%60);
var hours=~~((milliseconds/(1000*60*60))%24);
var days=~~((milliseconds/(1000*60*60*24))%365);
var years=~~((milliseconds/(1000*60*60*24*365))%1000);
return (years?years+'y ':'')+(days?days+'d ':'')+(hours?hours+'h ':'')+(minutes?minutes+'m ':'')+(seconds?seconds+'s ':'');
}
Tags (1)

## Re: Need help with date functionality.

Thanks a lot Carles

Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.