Newbie Questions

Re: How does I count workdays between two dates by managed code?

jatuphum — Fri, 09 Nov 2007 18:07:15 GMT

Hi Clay,

Thank you again. Because while loop from your Idea so now I can solve my problem.

Cheers.

Re: How does I count workdays between two dates by managed code?

Clay Fox — Fri, 09 Nov 2007 15:30:18 GMT

You would have to use more complex logic and calculate the number of Saturdays and Sundays between your two dates and then subtract that from your total. I believe with DateDiff there is a way to get day of week so you could use this to filter the results which would be counted and step through (while loop) each following date and if it was not a weekend add to your sum value.

Re: How does I count workdays between two dates by managed code?

jatuphum — Fri, 09 Nov 2007 07:17:22 GMT

Hi Clay,

Thank you for your reply. But I explain to you about my problem.

I don't want include of 'Saturday' and 'Sunday' of week.

May be I use loop for solve this problem?

Cheers.

Re: How does I count workdays between two dates by managed code?

Clay Fox — Wed, 07 Nov 2007 13:34:17 GMT

The common way is to use the Datediff function and VBscript. Many examples here but here is onewith code.

http://www.infopathdev.com/forums/p/5646/21172.aspx#21172

How does I count workdays between two dates by managed code?

jatuphum — Wed, 07 Nov 2007 10:24:09 GMT

Hi all,

I want to count workdays between two dates, such as 12 Dec 2007 to 11 Jan 2008.

I want to use by managed code.

Cheers.