Newbie Questions

Re: workdays calculation between 2 datepicker

william.ru — Thu, 22 Dec 2011 03:26:31 GMT

Hi Alec,

I want to add one more field "AM/PM" to calculate the work days. It looks like https://docs.google.com/document/d/1UeofM7q1QLku1m-a3Ok3D9OpCYXQDDSiFvpWIeUrtE8/edit. For example, I want to treat from "12-20-2011 AM" to "12-22-2011 AM" as 2.5 days.

Can you help to update your rules in your infopath form(Work days calculation (business days))?

Thanks,

Re: workdays calculation between 2 datepicker

Alec Pojidaev — Wed, 17 Nov 2010 14:31:26 GMT

In that case solution in my blog won't work for you. You need to calculate work days before data will hit InfoPath. Do some google search there is stored procedude that does what you need.

Re: workdays calculation between 2 datepicker

jenfi — Wed, 17 Nov 2010 13:59:52 GMT

its me again. My repeating group is connected to a sql server database. so i can not move the items to the repeating group.

if i understand what you are saying.

sorry for so much question. i'm very new at this

Re: workdays calculation between 2 datepicker

Alec Pojidaev — Tue, 16 Nov 2010 22:16:13 GMT

Create repeating group, then just right click on each and every nonrepeating fields (5 of them total) choose MoveTo, then move them one by one into your repeating section.

Re: workdays calculation between 2 datepicker

jenfi — Tue, 16 Nov 2010 22:02:15 GMT

wow, that is pretty fast.

thank you.

but my repeating table has 2 datepicker startdate and enddate in one row. so every time i click on insert in one row there is 2 datepicker.

do i have to also use 1 DateWN field for both datepicker.

i see that you are using 1 DateWN field for that 1 datepicker (Date).

Re: workdays calculation between 2 datepicker

Patrick Halstead — Tue, 16 Nov 2010 12:47:23 GMT

Hey Alec,

You rock! Thanks for responding with such a super post. Let us know what humble offering we can take to your shrine.

Re: workdays calculation between 2 datepicker

Alec Pojidaev — Mon, 15 Nov 2010 21:54:29 GMT

Done. Check it out.

Re: workdays calculation between 2 datepicker

jenfi — Mon, 15 Nov 2010 18:15:17 GMT

Yes i have ask Alec, he was about to post the code once he was less busy. but i tink he is still busy though

he explain to me about that xpath. but i'm not shure how to do that.

i'm gonna look for the blogs that have those techniques.

thnx for your reply

Re: workdays calculation between 2 datepicker

Patrick Halstead — Mon, 15 Nov 2010 00:55:39 GMT

Hi Jenfi,

Have you tried to ask Alec about this on his site? You probably need to modify your xpath to use current() or preceding-sibling. Try searching for those here. We have several blogs and posts about these two techniques.

We also provide qRules to solve this and many other common problems. qRules is a plug-in that you inject into your form. It gives you the most commonly asked for features that require code - you don't have to write any code. The trial is free and if you decide to use it, the cost is cheap. It's how we defray the cost of maintaining this free forum.

Thanks for your support,

workdays calculation between 2 datepicker

jenfi — Sun, 14 Nov 2010 21:24:07 GMT

hi, im trying to use the workday calculation of this site

http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

but the thing is i have to use this code for a repeating section.

i dont seem to see what i have to change so it can work for a repeating section. that has 2 datepicker and a field to calculate the days

can someone help me with this?

thnx