I guess the only way is to loop through all the dates and check their day of week. I was hoping there was something slicker, but it doesn't look like it.
Thanks Geert. that's some fine code there. -Ryan From: geert.jos...@daidalos.nl To: general@developer.marklogic.com Date: Thu, 16 Jun 2011 08:36:04 +0200 Subject: Re: [MarkLogic Dev General] Net Working Days calculation? Hi Ryan, Fun question! Hadn’t done it yet, but that doesn’t matter. How about this? It returns a list of all workable days. Wrap in a count to get a number. Perhaps not the fastest/smartest solution, but it should get you going.. import module namespace functx = "http://www.functx.com"; at "/MarkLogic/functx/functx-1.0-nodoc-2007-01.xqy"; let $holidays := (xs:date("2011-06-13")) (: second easter day:) let $start := xs:date("2011-06-09")let $end := xs:date("2011-06-16") return for $day in (0 to days-from-duration($end - $start)) let $date := $start + xs:dayTimeDuration(concat("P",$day,"D")) let $weekday := functx:day-of-week($date) let $is-weekend := ($weekday = (0, 6)) let $is-holiday := exists(index-of($date, $holidays)) where not($is-weekend) and not($is-holiday) return $date Kind regards,Geert Van: general-boun...@developer.marklogic.com [mailto:general-boun...@developer.marklogic.com] Namens seme...@hotmail.com Verzonden: donderdag 16 juni 2011 0:32 Aan: general@developer.marklogic.com Onderwerp: [MarkLogic Dev General] Net Working Days calculation? Has anyone done a Net Working Days calculation in XQuery? This would be the number of business days between a start and end date. Holiday inclusion would be awesome. -Ryan _______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general
_______________________________________________ General mailing list General@developer.marklogic.com http://developer.marklogic.com/mailman/listinfo/general
