Bonjour, 

Je cherche à créer une édition historique qui reprend tout le contingent d’Heures Supp faites depuis le début de l’année, avec les déductions associées en cas d’absence.

Je dois exclure les HSupp payées en Janvier qui ont été faites en Décembre parce qu’elles appartiennent au contingent 2023. Comment faire svp ? Le bornage des dates ne fonctionne pas. Ci-dessous mon extraction :

En-tête

Begin

Colonne010.titre = "HS 125%"
Colonne011.titre = "HS 150%"
Colonne012.titre = "HS 175%"
Colonne013.titre = "HS 200%"
End

Lignes

Begin

debut1 = Date(1,1,2024)
fin1 = Date(31,1,2024)
debut2 = Date(1,2,2024)

Colonne010 = CumulLignesBulletinsBaseS("debut2","","2","HS25","","","") + CumulLignesBulletinsBaseS("debut2","","2","","HS25","","") - CumulLignesBulletinsBaseS("debut1","fin1","2","HS25","","","") - CumulLignesBulletinsBaseS("debut1","fin1","2","","HS25","","")

Colonne011 = CumulLignesBulletinsBaseS("debut2","","2","HS50","","","") + CumulLignesBulletinsBaseS("debut2","","2","","HS50","","") - CumulLignesBulletinsBaseS("debut1","fin1","2","HS50","","","") - CumulLignesBulletinsBaseS("debut1","fin1","2","","HS50","","")

Colonne012 = CumulLignesBulletinsBaseS("debut2","","2","HS75","","","") + CumulLignesBulletinsBaseS("debut2","","2","","HS75","","") + CumulLignesBulletinsBaseSSelonLibelle("debut2","","2","C01","","","","Heures supplémentaires 75%") - CumulLignesBulletinsBaseS("debut1","fin1","2","HS75","","","") - CumulLignesBulletinsBaseS("debut1","fin1","2","","HS75","","") - CumulLignesBulletinsBaseSSelonLibelle("debut1","fin1","2","C01","","","","Heures supplémentaires 75%")

Colonne013 = CumulLignesBulletinsBaseS("debut2","","2","HS100","","","") + CumulLignesBulletinsBaseS("debut2","","2","","HS100","","") - CumulLignesBulletinsBaseS("debut1","fin1","2","HS100","","","") - CumulLignesBulletinsBaseS("debut1","fin1","2","","HS100","","")

End

PS : Quand j’intègre directement les HSupp via un fichier csv, les heures supp générées ne portent plus de marque interne de type HS25 etc, mais un code libellé, d’où la nécessité d’inclure les deux dans mon extraction.

Merci d’avance pour votre aide !!