General

Re: coutdown field

kac.dev — Wed, 09 May 2012 13:41:45 GMT

Dear Sir, I am new user of Infopath and have no basic knowledge of script. Please any one help me to how to put these code and where ? Thank you

Re: coutdown field

Jimmy — Thu, 06 Nov 2008 16:26:30 GMT

Yes, it should, as this is VBScript.

Re: coutdown field

Scotl — Wed, 05 Nov 2008 19:29:25 GMT

This script will work in InfoPath 2003?

Re: coutdown field

jkrdoom — Mon, 06 Mar 2006 16:02:34 GMT

Thanks I'll give it a shot.

Re: coutdown field

Stephanie Cantwell — Mon, 06 Mar 2006 01:21:27 GMT

Here is the code sample using VBScript. You need to call it from OnAfterChange event.

Sub UpdateDateDiff
Dim fromDate
Dim toDate
Dim days
Dim daysNode

set daysNode = XDocument.DOM.selectSingleNode("/my:myFields/my:DaysRemaining")

fromDate = Trim(XDocument.DOM.selectSingleNode("/my:myFields/my:FromDate").text)
toDate = Trim(XDocument.DOM.selectSingleNode("/my:myFields/my:ToDate").text)

if Len(fromDate) = 0 Or Len(toDate) = 0 Then
daysNode.text = "n/a"
else
fromDate = CDate(fromDate)
toDate = CDate(toDate)
days = DateDiff("d", fromDate, toDate)

' Determine whether the xsi:nil attribute is set for this
' element. If so, remove the xsi:nil attributes so that
' the value can be set.
if Not IsNull(daysNode.getAttribute("xsi:nil")) then
daysNode.removeAttribute("xsi:nil")
end if
daysNode.text = CStr(days)
end if
End Sub

Re: coutdown field

jkrdoom — Sun, 05 Mar 2006 23:07:27 GMT

I have a confession to make. I've got no coding knowledge whatsoever. I work for a company that does lit support(e-discovery, digital forensics, legal database production). We have don't have any programmer's on our staff and somehow I've gotten stuck heading up the devolpment of tracking systems for our workflow.Sadness!!! I was doing fine with rules and formula until I started coming up with more ambitiuos designs. Looks like I'm going to have to learn basic coding!!!

Long story short I'm frightened and lost in the wonderful world of coding!!!

Re: coutdown field

Stephanie Cantwell — Sun, 05 Mar 2006 22:46:54 GMT

It sounds like you don't have Visual Studio. Your options will be either VBScript or JScript. The code will be a bit different for each. Are you familiar at all with VB?

Re: coutdown field

jkrdoom — Sun, 05 Mar 2006 22:42:29 GMT

Not doing anything with code. I'm just using rules and formula for what I need.

...should I send money??? :>

Re: coutdown field

Stephanie Cantwell — Sun, 05 Mar 2006 22:22:39 GMT

What language are you using? I can write a little piece of code to help out.

Re: coutdown field

jkrdoom — Sun, 05 Mar 2006 22:19:08 GMT

Looks like I'll have to use code and a few bottles of wine to deal with this!!

Thanks

Re: coutdown field

Stephanie Cantwell — Sun, 05 Mar 2006 22:05:23 GMT

Unfortunately there is no DateDiff formula in InfoPath. You have use code.

Re: coutdown field

jkrdoom — Sun, 05 Mar 2006 21:35:21 GMT

perfect!!!

The only problem is code makes cry! :>
Is there a way I could do this with the fields value formula?

Re: coutdown field

Stephanie Cantwell — Sun, 05 Mar 2006 21:30:28 GMT

This article has information regarding Date Calculations in InfoPath, which might answer your first question.

http://blogs.msdn.com/infopath/archive/2005/01/25/360318.aspx

coutdown field

jkrdoom — Sun, 05 Mar 2006 21:20:43 GMT

I need to have a field that displays the number of days left for a project. I have a field showing todays date, and one showing the project deadline date. I'd like to display the remaing days in a 3rd field. I'd also like to disable the 3rd control once the deadline has been met.