Difference between time in seconds

Liberty Create - Build Advice
1

Hi All,

I know it sounds bit simple but I’m not able to get the difference between two time fields in seconds.
I have an object with two time properties(From and To)and I’m trying to get the difference on the change of any of these two fields in seconds.
I have created a composite field of type Numeric calculation and output base format as time but I’m not getting the correct result.

Thanks,
Vishal

2

Hi Vishal
I have moved your question to Build Advice. Definitely fits there! I’ll get one of our propeller heads to come back to you soon as.
Cheers, Tony

3

Hi Vishal,

What version of the platform are you using?

Richard

4

Hi Vishal,

I’ve assumed you’re on a v10+ version.

Create two composites from the two date time fields with function “Add Interval (returns timestamp)”, the interval subject can be left to default days and the interval value set to 0:

Unknown
Unknown.png1314×527 22.8 KB

Unknown-1
Unknown-1.png1305×512 22.9 KB

The create another composite of type “Numeric Calculation” with the output base format of Integer:

The calculation is “Second Composite – First Composite”:

Unknown-2
Unknown-2.png1327×530 23.7 KB

The output of that composite is the time difference in seconds.

Richard

5

Hi Richard ,

I’m using 10.0 version.

Thanks,
Vishal

6

Hi Vishal,

Great, my reply above should work for you then.

Richard

7

Thanks Richard . That worked for me .
I was wondering how to trigger the calculation on the change of time 1 and time 2 property . As of now, difference is calculated only when the values are saved on click of submit.

8

Hi Vishal,

It’s only possible at the point you save the value.

If you need this to recalculate without submission then the only option would be a Code Studio callback function. That would also require a later version of the platform so you’d need to schedule an upgrade via your Account Manager.

Richard

9

Thanks, Richard.
I will check for the upgrade .