Features / Usability

Posted by Mike Finko 19 Aug 2020 14:25 GMT-0000 posts: 228

I decided to try a different approach - using 'seconds' of UNIX time.

(round(div(div(date(sub futuredate (date)))60)60)1)

In the Tracker it displays correctly (in hours)
In PluginLIST it's best not to use the 'date/time' formatting but a simple 'number':

{FORMAT(name="Time to Date")}{display name="tracker_field_futuredate" default=" " format=number }{FORMAT}

This is for a 'simple' use case, as it will also calculate hours in reverse (which, may or may not be useful).