You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

dynamic calculation and display of units on oj-table column

edited Jul 30, 2019 5:03PM in Visual Builder 10 comments

Content

I have a table populated from SDP variable BO data.

Requirement: Two of the columns in this table are datetime fields. I need to generate a new column or I have already created an empty column in the table. This 3rd column should contain or  has to calculate and display the difference between these 2 datetime fields. 

say my startTime:  2019-06-19T14:37:46 and endTime: 2019-06-19T14:38:22..  the 3rd column has to display diffinTime:  00:00:36

User has to know the time taken by looking at the difference in seconds/minutes/hours/days.

Please provide pointers

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!