I want to find the difference between the two date time fields and need to update in other duration field

[venkataci]

I want to find the difference between the two date time fields and need to update in other duration field.

   Log in Time and Logoff time are Date/ Time fields and Total Log time is duration field.

I have written server side script for this to work calling a glide ajax call. But it is not calculating the difference.

Client script:

Script include is:

Please help me to resolve it.

Thanks in Advance.

[Venkateswarlu K]

Just Now tested

[venkataci]

Yes i tried with yours..

small correction..

Here i am using  Login and Logout are Duration fields but you are using Date/Time fields.

So i am getting a different values..even the years also got changed.

i modified field names as per my table. And executed your code. So i am seeing these values.

[Venkateswarlu K]

Hi Venkat Login Value greater than the logout value in ur testing ur using the january month try with different days and months i hope this will works fine 

I need one clarification here filnally what do u want duration?? or just like days hours minites seconds?

Thanks&Regards

Venkateswarlu K

[venkataci]

Hi venkat,

The values which i entered in Login Time and Logoff time are different to the displayed values.

And i entered Login time less than Logoff time only.

And i entered march, but not january. 

[Venkateswarlu K]

Hi Venkat

Did u got the solution for this thread if yes then close the thread by making correct if no tell me how can we help you in better way

Thanks & Regards

Venkateswarlu K