InfoPath Dev

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

 K 

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.

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

K

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.