Toggle menu
862
3.8K
30.2K
279.1K
Catglobe Wiki
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

DateTime workDaysBetween: Difference between revisions

From Catglobe Wiki
Cg_pham (talk | contribs)
No edit summary
Cg van (talk | contribs)
No edit summary
 
Line 2: Line 2:
{{HelpFiles}}
{{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