General

Re: Calculate a time taken to complete a Task

Hilary Stoupa — Mon, 29 Oct 2012 15:08:52 GMT

What version of InfoPath are you using? If you are using IP 2007 or greater, use managed code instead of jscript.

This blog post may help you.

Re: Calculate a time taken to complete a Task

Tank86 — Sat, 27 Oct 2012 08:24:55 GMT

Hi, thanks for the response getting 3rd party software installed on our servers is not easy and therefore think code would be easier if i could.

Thanks

Re: Calculate a time taken to complete a Task

Anson Hidajat — Fri, 26 Oct 2012 18:12:37 GMT

qRules has a DateDiff command which you can use to easily determine the difference between two date fields: http://www.qdabra.com/en/products/qRules_new.aspx

Otherwise, you're likely looking at some custom code to implement this.

Calculate a time taken to complete a Task

Tank86 — Fri, 26 Oct 2012 14:40:33 GMT

Hi,

I have a form where it contains a start date and time, and an end date and time. I am trying to work out how long the task was open for based on working days and times... Monday to Friday 09:00 to 17:30.

Does anyone know how i could calculate this using jscript code, or any other way?

Manny Thanks