SELECT Id, Presentateur, Titre, artiste, date_debut, date_fin,Heure_debut FROM Agenda3 WHERE Langue IN ('en','fr','fr/en')Langue LIKE '%fr%' AND date_debut <= #CreateODBCDate("{d '#Year("#attributes.Jour#")#-#Month("#attributes.Jour#")#-#DaysInMonth("#attributes.Jour#")#'}")# AND date_fin >= #CreateODBCDate("{d '#Year("#attributes.Jour#")#-#Month("#attributes.Jour#")#-1'}")##PreserveSingleQuotes(Var.QUERY)##PreserveSingleQuotes(QryAgendaActif)# ORDER BY date_debut, date_fin

CalendrierAgenda

dim.	lun.	mar.	mer.	jeu.	ven	sam.
	class="cal_a"> cal_acal_j">0#datecount#">#datecount# #TimeFormat(Heure_debut, "H")#:#TimeFormat(Heure_debut, "mm")# #artiste##Titre#
class="cal_a"> cal_acal_j">0#datecount#">#datecount# #TimeFormat(Heure_debut, "H")#:#TimeFormat(Heure_debut, "mm")# #artiste##Titre#