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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.