Grid and date time subtraction in runtime

I have two attributes in one of my entities: StartTime and EndTime. In runtime I would like to fill a column of my grid with the subtraction of EndTime from StartTime, but converted to an integer. Is it possible to do that using a grid?
1 answers

You can use Date function calls to get the time difference between StartTime and EndTime as a decimal value as described here:

You can then round (or floor or ceil) that value to an integer as described here:

To display this value in a grid, you will need an integer attribute member on your entity. This could be a calculated attribute as described here:

If the data source of your list is a microflow, you can calculate the value in this microflow in a loop, then you would not need a calculated attribute.

Hope this helps,