Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I calculated the runtime by the interval(EndTimeStamp - StartTimeStamp) and the result is hh:mm:ss
Now if I do hour(runtime) I get the right value for all the intervals which have hour <= 23
If my interval is longer than 24 hours, the system always display 23. For example:
EndTimeStamp 11 - december - 2012 15:00:00
StartTimeStamp 8 december 2012 13:00:00
The interval is 70:00:00 but it displays 23 and it's wrong
Any help for me ? Thanks in advance for your help
To get hour use interval function itself
Interval(runtime, 'hh')
because hour is upto 23 hours only it consider hour for a day.
Thanks very much !!!