Hi
I'm a jnr developer in need of desparate help. Can anyone point me in the right direction for this problem:
I calculate the number of days between 2 user defined dates like this:
Dim DaysInRange As Long
DaysInRange = DateDiff("d", Me.dtp_firstdate.Text, Me.dtp_lastdate.Text) + 1
mod_rptStaffCaseloadAnalysis.p_numDaysInSelectedPe riod = DaysInRange
What I need to do now, is work out the number of weekdays (Mon-Fri) between the dates selected by the user.
I am completely stumped.
Can anyone provide some pointers?
Thanks!
--------------------------------
From: Chris Hill
-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)
<Id>h2uGpHNzI0OuwyE/NFvrug==</Id>