Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Calculate end time from start time and duration in confiforms

Anne EQS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 5, 2016

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

 

 

2 answers

0 votes
Alex Medved _ConfiForms_
Community Champion
June 10, 2019

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)
0 votes
Anne EQS
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 5, 2016

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?

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events