DateTime workDaysBetween - Revision history

Cg van at 10:12, 21 December 2011

2011-12-21T10:12:03Z

← Older revision		Revision as of 10:12, 21 December 2011
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-->

Cg_pham at 08:37, 12 December 2011

2011-12-12T08:37:40Z

← Older revision		Revision as of 08:37, 12 December 2011
Line 1:		Line 1:
	[[Category:General_Functions]]		[[Category:General_Functions]]
	~~http://www.swype.com/tips/swype-basics/~~		{{HelpFiles}}

	====DateTime_workDaysBetween====		====DateTime_workDaysBetween====

Cg_pham at 08:37, 12 December 2011

2011-12-12T08:37:29Z

← Older revision		Revision as of 08:37, 12 December 2011
Line 1:		Line 1:
	[[Category:General_Functions]]		[[Category:General_Functions]]
			http://www.swype.com/tips/swype-basics/

	====DateTime_workDaysBetween====		====DateTime_workDaysBetween====

Cg_pham at 08:54, 21 March 2011

2011-03-21T08:54:48Z

← Older revision		Revision as of 08:54, 21 March 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:General_Functions]]

Catglobe: jrfconvert import

2011-03-07T08:59:22Z

jrfconvert import

New page

[[Category:HelpBooks]]

====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
__NOTOC__