Date Diff Calculation VBScript - Help Repeating Section

[Scott]

I used a Date Difference Calculation function and sub routine using three
fields in a repeating section, two date pickers and one text, same as
outlined in other posts which works fine. This is the link to the procedure.
http://enterprise-solutions.swits.net/infopath/datediff-vbscript-infopath.htm

I run into problems when I repeat the section in that I can select the
dates I want in date picker fields, but the Date Difference field doesn't
calculate the difference. It only works the first time, not for subsequent
sections.

How can I get this to work in a repeating section so I can enter in all new
date information every time I repeat the section. This is for call center
tracking and each issue has potential different start and end date and I need
to track how long each call is taking.

Thanks for help

 

[suresh Reddy]

Hi Scott,

Try out this link

http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=1060

Hope this will help You,
Thank You.

 

[Scott]

That Suresh. I read that article and it was created using the .Net Framework.
My form is using VB and Windows Scripting, so I can't use this example.

Any thoughts? Should I change the scripting for my form?

 

[S.Y.M. Wong-A-Ton]

Hi Scott,

Sorry for the delay. Have you already taken a look at this link?

http://enterprise-solutions.swits.net/infopath/date-time-difference-calculations-vbscript.htm

It's slightly different than the one you used (it also implements time
fields), but it makes use of a repeating table. Note: A repeating section
works the same way as a repeating table (it's uses same concept).

Hope this helps.

 

[Scott]

Thanks. I took that date time diff script and tried to use it in a repeating
section, but it didn't calculate. Its very frustrating because I have tried
numerous ways, but it doesn't appear possible to have a Date Difference
function in a repeating section, so that each time the section repeats it
will calculate the new Date Difference.

 

[S.Y.M. Wong-A-Ton]

Scott,
I'm unable to take a closer look at using the code with a repeating section
right now since I'm out of the office and don't have InfoPath available, but
if you can hang on for another 2-3 weeks, I can look into your problem.

 

[Scott]

Anything you can do to assist is greatly appreciate.
Thank you very much
Scott

 

[S.Y.M. Wong-A-Ton]

Hi Scott,

Thank you for your patience. I substituted the repeating table for a
repeating section in a form and it worked. The only thing I can think of why
it isn't working on your side is that you probably removed the time fields
and did not remove the corresponding checks on these fields being empty from
the functions that perform the calculations?

 

[Scott]

SYM,

Your process works fine on first section, but when the section repeats it
stops working. Any thoughts? Were you able to get this process working on a
repeating section, so that is calculate differently for each new section
added?

Scott

 

[Scott]

Bump..

SYM, are you still around to look at this?
Thanks

 

[S.Y.M. Wong-A-Ton]

Hi Scott,

Sorry, I missed your previous post. Yes, I got it to work with a repeating
section.

Go to this page http://www.unspoilt.net/cgi-bin/contact.pl and send me an
message with your email address. We'll then try to troubleshoot your form
from there, okay?