Calculate end time from start time and duration in confiforms

Question

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

* Condition '!plannedstarttime:[empty]'
* Action 'Set value'
* Values to set 'plannedendtime=[entry.plannedstarttime]+days(1)'

Expected results would be endtime =starttime plus 1 day, but the result looks like

Bildschirmfoto 2016-09-05 um 14.49.17.png

Alex Medved _ConfiForms_ · Answer

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)

Anne EQS · Answer

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?