Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
request Date: 02/11/2016 (format: dd/mm/yyyy)
Closing Date: 02/11/2016 (format: dd/mm/yyyy)
Request Time: 85034 should be 08:50:34
Closing Time: 112701 should be 11:27:01
Elapsed Time: (Closing Time - Request Time)
How could I determine elapsed time?
While Loading...use below
Time(Time#(Num([Request Time],'000000'),'hhmmss')) as [Request Time],
Time(Time#(Num([Closing Time],'000000'),'hhmmss')) as [Closing Time].
...
...
..
Now you can use as below at front end
Interval([Closing Time] - [Request Time])