= #CreateODBCDate("#now()#")# AND date_debut <= #CreateODBCDate("#now()#")#"> = {d '#DateFormat("#now()#","yyyy-mm")#-01'} AND date_debut < #DateFin#"> SELECT Id, Web, Titre, Description,Lieu, Ville, Province, Region, Presentateur, Information, date_debut, date_fin,Photo_mini FROM Agenda3 WHERE Langue LIKE '%fr%'#PreserveSingleQuotes(attributes.QUERY)# AND Repertoire_No=#attributes.Repertoire_No##PreserveSingleQuotes(QryAgendaActif)# ORDER BY Province, Region, niveau5 desc, date_debut