1 2 3
|
sum(xdXDocument:GetDOM("Base des jours feriés")/dfs:myFields/dfs:dataFields/dfs:Base_des_jours_feriés/@Année[(. = 2011) and (msxsl:string-compare(number(substring(../@Date, 9, 2)) + floor((153 * (number(substring(../@Date, 6, 2)) + 12 * floor((14 - number(substring(../@Date, 6, 2))) div 12) - 3) + 2) div 5) + (number(substring(../@Date, 1, 4)) + 4800 - floor((14 - number(substring(../@Date, 6, 2))) div 12)) * 365 + floor((number(substring(../@Date, 1, 4)) + 4800 - floor((14 - number(substring(../@Date, 6, 2))) div 12)) div 4) - floor((number(substring(../@Date, 1, 4)) + 4800 - floor((14 - number(substring(../@Date, 6, 2))) div 12)) div 100) + floor((number(substring(../@Date, 1, 4)) + 4800 - floor((14 - number(substring(../@Date, 6, 2))) div 12)) div 400) - 32045, number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 9, 2)) + floor((153 * (number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 6, 2)) + 12 * floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 6, 2))) div 12) - 3) + 2) div 5) + (number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 1, 4)) + 4800 - floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 6, 2))) div 12)) * 365 + floor((number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 1, 4)) + 4800 - floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 6, 2))) div 12)) div 4) - floor((number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 1, 4)) + 4800 - floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 6, 2))) div 12)) div 100) + floor((number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 1, 4)) + 4800 - floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:endDate, 6, 2))) div 12)) div 400) - 32045) <= 0) and (msxsl:string-compare(number(substring(../@Date, 9, 2)) + floor((153 * (number(substring(../@Date, 6, 2)) + 12 * floor((14 - number(substring(../@Date, 6, 2))) div 12) - 3) + 2) div 5) + (number(substring(../@Date, 1, 4)) + 4800 - floor((14 - number(substring(../@Date, 6, 2))) div 12)) * 365 + floor((number(substring(../@Date, 1, 4)) + 4800 - floor((14 - number(substring(../@Date, 6, 2))) div 12)) div 4) - floor((number(substring(../@Date, 1, 4)) + 4800 - floor((14 - number(substring(../@Date, 6, 2))) div 12)) div 100) + floor((number(substring(../@Date, 1, 4)) + 4800 - floor((14 - number(substring(../@Date, 6, 2))) div 12)) div 400) - 32045, number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 9, 2)) + floor((153 * (number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 6, 2)) + 12 * floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 6, 2))) div 12) - 3) + 2) div 5) + (number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 1, 4)) + 4800 - floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 6, 2))) div 12)) * 365 + floor((number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 1, 4)) + 4800 - floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 6, 2))) div 12)) div 4) - floor((number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 1, 4)) + 4800 - floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 6, 2))) div 12)) div 100) + floor((number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 1, 4)) + 4800 - floor((14 - number(substring(xdXDocument:get-DOM()/my:mesChamps/my:startDate, 6, 2))) div 12)) div 400) - 32045) >= 0)]) div 2011 |
Partager