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.
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
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?
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.
Thank you again. Because while loop from your Idea so now I can solve my problem.