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

Elapsed time.

SOLVED
Highlighted
Garnet

Elapsed time.

Hi folks,

How to show/calculate time between first and last row in Data Table.
Krzysztof
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Elapsed time.

DataTable or InfoTable?

 

Infotable:

var timeBetween = dateDifference(yourInfotable.rows[0][timestampField],yourInfotable.rows[yourInfotable.rows.length-1][timestampField]);

DataTable:

var yourInfotable = yourDataTable.GetGetDataTableEntries({ maxItems: 1000000 });
// -- Here the previous code, you may need to sort the yourInfotable by timestampField...
1 REPLY 1

Re: Elapsed time.

DataTable or InfoTable?

 

Infotable:

var timeBetween = dateDifference(yourInfotable.rows[0][timestampField],yourInfotable.rows[yourInfotable.rows.length-1][timestampField]);

DataTable:

var yourInfotable = yourDataTable.GetGetDataTableEntries({ maxItems: 1000000 });
// -- Here the previous code, you may need to sort the yourInfotable by timestampField...