More actions
No edit summary |
No edit summary |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
[[Category:General_Functions]] | [[Category:General_Functions]] | ||
{{HelpFiles}} | |||
====DateTime_workDaysBetween==== | ==== DateTime_workDaysBetween ==== | ||
Return number of work days between two datetimes | Return number of work days between two datetimes | ||
'''Syntax''' | '''Syntax''' | ||
DateTime_workDaysBetween(datetime1, datetime2[, array listOfHoliday][, timeZoneId]) | DateTime_workDaysBetween(datetime1, datetime2[, array listOfHoliday][, timeZoneId]) | ||
'''Arguments''' | '''Arguments''' | ||
* datetime1, datetime2: date time object array | *datetime1, datetime2: date time object array | ||
* istOfHoliday: list of holiday datetime object array | *istOfHoliday: list of holiday datetime object array | ||
* timeZoneId: Id of timeZone | *timeZoneId: Id of timeZone | ||
'''Return value''' | '''Return value''' | ||
number | number | ||
'''Example''' | '''Example''' | ||
array a1 = {2009,6,8,10,10,10,10,19,57}; | ''array a1 = {2009,6,8,10,10,10,10,19,57}; '' | ||
array a2 = {2009,6,15,12,12,12,10,23,57}; | ''array a2 = {2009,6,15,12,12,12,10,23,57}; '' | ||
array holiday1 = {2009,6,9,12,12,12,10,23,57}; | ''array holiday1 = {2009,6,9,12,12,12,10,23,57}; '' | ||
array holiday2 = {2009,6,10,12,12,12,10,23,57}; | ''array holiday2 = {2009,6,10,12,12,12,10,23,57}; '' | ||
number timezoneid = 57; | ''number timezoneid = 57; '' | ||
print(DateTime_workDaysBetween(a1, a2, {holiday1, holiday2},timezoneid)); | ''print(DateTime_workDaysBetween(a1, a2, {holiday1, holiday2},timezoneid)); '' | ||
// result = 3 | ''// result = 3 '' | ||
'''Availability''' | '''Availability''' | ||
Version 5.7 | Version 5.7 __NOTOC__ <!-- imported from file: 7554.htm--> | ||
__NOTOC__ | |||
<!-- imported from file: 7554.htm--> | |||
Latest revision as of 10:12, 21 December 2011
DateTime_workDaysBetween
Return number of work days between two datetimes
Syntax
DateTime_workDaysBetween(datetime1, datetime2[, array listOfHoliday][, timeZoneId])
Arguments
- datetime1, datetime2: date time object array
- istOfHoliday: list of holiday datetime object array
- timeZoneId: Id of timeZone
Return value
number
Example
array a1 = {2009,6,8,10,10,10,10,19,57};
array a2 = {2009,6,15,12,12,12,10,23,57};
array holiday1 = {2009,6,9,12,12,12,10,23,57};
array holiday2 = {2009,6,10,12,12,12,10,23,57};
number timezoneid = 57;
print(DateTime_workDaysBetween(a1, a2, {holiday1, holiday2},timezoneid));
// result = 3
Availability
Version 5.7