time between 2 dates in second

[#1]

hi everybody

I search to obtain time difference between 2 dates in second. In my expression i do

Interval(DATE_END-DATE_START,'hhmmss')

for example i have 030200 it means 3 hours 2 min and zero second.

i would like have result in second equals to 10920 seconds

function second on result give me zero

thx for your help

[Anonymous]

Hi,

You should be able to do this:

Interval(Today()-(Today()-1),'ss');

[#3]

thx

you are speed;)

it is ok if i make

Interval(DATE_END-DATE_START,'ss')