Code

Re: Datediff ?

rg66 — Sun, 12 Feb 2006 16:52:17 GMT

Just found out what I was missing!

I started the form and the editor in JScript and not as VBScript. So I will redo the form in VBScript.

Will test your script out then. Thank you!

Robert

Re: Datediff ?

rg66 — Sun, 12 Feb 2006 16:46:14 GMT

sandeep,

thank you for the code script.

Just one question: Do I have to place this in the script.js file? Or is there a different place I have to use?

Robert

Re: Datediff ?

sandeep — Sun, 12 Feb 2006 12:44:26 GMT

Hi rg66

Try this VBscript code

Dim date_from
Dim date_to
Dim dt1Val
Dim dt2Val
Dim daysElapsed

Set date_from = XDocument.DOM.selectSingleNode("/my:myFields/my:date_from")
Set date_to = XDocument.DOM.selectSingleNode("/my:myFields/my:date_to")

dt1Val = CDate(date_from.Text)
dt2Val = CDate(date_to.Text)

daysElapsed = DateDiff("d", dt1Val, dt2Val)

XDocument.DOM.selectSingleNode("/my:myFields/my:field3").text = daysElapsed

Thanks

Sandeep
InfoPath Dev India

Re: Datediff ?

rg66 — Sun, 12 Feb 2006 10:00:36 GMT

Matt,

thank you!

But I am trying to get the basic first and I am struggling here.

Can you recomment a jscript book in correlation with infopath which explains how to use jscript in infopath.

I am currently trying to make a OnAfterChange Procedure and what I trying to do is read an entry from a textfield and write it in a different one.

I am getting kind of frustrated as I have search google now and I even have a book from Microsoft, which has helped me to get started but now I need to write a script and I have no idea how to do that. The documentation is really bad, I have to say.

Any help?

Robert

Re: Datediff ?

Matt Faus — Sat, 11 Feb 2006 18:42:55 GMT

Check out this awesome tutorial:

http://enterprise-solutions.swits.net/infopath/adding-time-calculating-differences.htm

---------------
Matt Faus
InfoPath Dev Texas

Datediff ?

rg66 — Sat, 11 Feb 2006 17:10:21 GMT

Hello,

I have two date fields which are called date_from and date_to. I want to calculate the datediff from these two fields.

WHat I need to know is:

1. How do I read the entry from both fields in jscipt or vbscribt?
2. Make the calculation, is Datediff available om both script level?
3. Return/write the result in another field within the form

Can some one help or direct me?

Best regards,

Robert