Calculate Elapsed Time

[alexcharleswort]

This is a simple question, but I am truly atrocious with anything involving calculating date/times.

I have two date/time variables (u_start, u_end). What I want to have happen is to populate another variable (u_elapsed) on the form telling me how much time has elapsed.

I assume I would do an onSubmit client script that calculate (u_end - u_start), but I'm not sure how to write it the proper way and what sort of variable u_elapsed should be for it to populate correctly? String, integer, decimal?

Thanks in advance for your help!

[Subhajit1]

u_elapsed can be a Date-Time variable.

You can use GlideAjax to send the u_start and u_end values to Server side, use the gs.dateDiff() method to calculate the difference and bring the difference value back to the Form through Return and set the value on u_elapsed.

You can refer to the following link for more information:-

Client Script Date/Time Functions

[Kalaiarasan Pus]

http://wiki.servicenow.com/index.php?title=GlideSystem_Date_and_Time_Functions#dateDiff.28String.2C_...

[Abhinay Erra · Accepted solution]

Here you go. Elapsed time should be of duration type and here is how your code will look like. Put this script in the before business rule

Before insert and update

script:

current.u_elapsed.setDisplayValue(gs.dateDiff(current.u_start.getDisplayValue(),current.u_end.getDisplayValue(),false));