I'm looking for an way to calculate the end time of an event from a start time and a known duration.
The data should be preset, but still editable for the user.
What field type should I use - datetime or datime interval?
And how do I define an interval in minutes?
I defined fields 'plannedstarttime' and plannedendtime' of field type 'Datetime'
and a rule for field definition with
Expected results would be endtime =starttime plus 1 day, but the result looks like
Bildschirmfoto 2016-09-05 um 14.49.17.png
Date (datetime, timestamp) fields in ConfiForms do operate with timestamps and you shall set the value of 1 day in milliseconds
And you shall use set expression as action in the rules
plannedendtime=([entry.plannedstarttime]+86400000)
1473073200000 - Sep 05, 2016 13:00
1473078600000 - Sep 05, 2016 14:30
Plus 90 min then would be +5400000, but how do I get it calculated?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.