SELECT Id, Presentateur, Titre, date_debut, date_fin FROM Agenda3 WHERE 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#
  • #Titre#
    •
    class="cal_a">
    cal_acal_j">0#datecount#">#datecount#
  • #Titre#
    •