Difference between revisions of "DateTime workDaysBetween"
| (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 11: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
