mathematical calculation tracker field
Why start a new topic when you can re-use a topic you started 6 years ago
I could use some advice again, this time for calculating time between two dates -
I'm trying to calculate the difference between the current date and one in the future. I have a Date and Time Picker field for the future date (let's call it 'futureDate'). So in the mathematical calculation field I already tried a number of variations:
Copy to clipboard
(date(sub futureDate now)) (date(sub futureDate current)) (date(sub futureDate today)) (date(sub futureDate now()))
I checked on the php page https://www.php.net/manual/en/function.date.php for these variables, but none worked.
Also, how would I format it in hours/min.? or days?
Any thoughts?
Thanks,
Mike