15
Views
4
Comments
Solved
Sql
Question

 How do you calculate the difference between logging in and logging out using Sql

Rank: #70
Solution

Hi Andrew,


On your aggregate, you can add a new attribute (using the New attribute button) and make use of OutSystems built-in functions DiffDays, DiffHours, DiffMinutes or DiffSeconds to get the difference between two date times. Something like in the example below where I use the DiffHours function:


 

Hope it helps.


Regards,
João

Rank: #2836