find period in days / hours excluding weekdays between two days?

[Segvoia]

Hi,

Is there any way of calculating the total period between the two dates in days or hrs excluding the weekdays?

[Modifier]

USE DateDiff Function

DateDiff(DateInterval.Day, dtmStart, dtmEnd)

Public Overloads Function DateDiff( _
   ByVal Interval As String, _
   ByVal Date1 As Object, _
   ByVal Date2 As Object, _
   Optional ByVal DayOfWeek As FirstDayOfWeek = FirstDayOfWeek.Sunday, _
   Optional ByVal WeekOfYear As FirstWeekOfYear = FirstWeekOfYear.Jan1 _
) As Long

You need to assign values to dtmStart(start date) & dtmEnd(end date).

http://msdn.microsoft.com/en-us/libr...6f(vs.71).aspx

[Coldman]

I have the same question for python language?

Please help me.

[NetWorm]

Python(Script)
This will return the number of days between two dates. In the script I'm using ZopeTime but I can be changed if necessary. Most of the clues to this puzzle were gathered from the Zope List.
Source
from DateTime import DateTime
date1 = DateTime('2001/10/06 14:00:00')
date2 = context.ZopeTime()
return str(date1 - date2)[:2]
Add a script(Python) called time_lapse and paste the source from above.
The returned number of days can then be referenced with the <dtml-var time_lapse>
for details: http://www.zopelabs.com/cookbook/997725258