Code

Re: Infopath 2003

Hilary Stoupa — Thu, 06 Nov 2008 02:00:12 GMT

Okay. First you'll need to set your form's programming language to VBScript. I don't remember exactly where that is in IP2003 -- in 2007, it is under Tools/Form Options/Programming. You can right click the date field your user is entering their start date, and in the context menu, under Programming, select the On After Change event. This will add the event to your form and open the script editor.

The sample code gets the difference between two dates that are entered in the form and enters the days between the dates in a text box. To do what you need, the script would look more like this:

Dim start
Dim startDate
Dim diff
Set start = XDocument.DOM.selectSingleNode("/my:myFields/my:field1")

If start.text = "" Then
Exit Sub
End If

startDate = CDate(start.text)
diff = DateDiff("d", startDate, Date) XDocument.DOM.selectSingleNode("/my:myFields/my:field2").text = diff

This VBScript gets the number of days between today and a field (field1) in the form, then returns that value in field2 in the same form. To get years and days, you'll need to divide diff by 365 for the years, and then get the remainder for days.... Hope this helps!

Re: Infopath 2003

Scotl — Wed, 05 Nov 2008 20:11:13 GMT

I am providing a calculation form for my staff. It allows them to find where they stand in a selection process for offices.

I need to calculate their time of service.

I am hoping to find a formula where I can take the Current Date 'today()' when using InfoPath 2003 functions and subtract a date in which they would enter in one field.

I need to take the difference and display the Years and days

Re: Infopath 2003

Hilary Stoupa — Wed, 05 Nov 2008 19:26:52 GMT

Well, if you are using IP 2003 and are not using Visual Studio, you'll need to use JScript or VBScript. Code goes into form events, so you need to add an event to the field or action that should trigger the date calculation. Can you provide some more information about the types of date calculations you need to do?

Re: Infopath 2003

Scotl — Wed, 05 Nov 2008 17:52:59 GMT

Hilary,

Thanks for access to the template.

I will use whatever is best to get the job complete. All the codes go in the Fx section of the formula placement section in InfoPath 2003, correct?

I was told that several formulas for subtracting dates were not possible until 2007.

Jeff

Re: Infopath 2003

Hilary Stoupa — Wed, 05 Nov 2008 15:39:03 GMT

Hi, and welcome!

I created a 2003 version of a template I made with some samples to get the days, months and years using rules. You can find that here.

As far as date math, in IP 2003, you'll need to use code for that. Are you using script or managed code?

Infopath 2003

Scotl — Wed, 05 Nov 2008 15:24:31 GMT

I am a newbie, self teaching my self the basics for creating form and codes

What are the codes for days, months, years?

How can I subtract on day from the current date Today()

How can I find the difference between Today () and a date that is entered into a field by a user?

Thanks