= #CreateODBCDate("#now()#")#">
= #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,niveau2,niveau5,entree,modification,source_id,pageid
FROM Agenda3
WHERE Langue LIKE '%fr%'#PreserveSingleQuotes(attributes.QUERY)# AND Repertoire_No=#attributes.Repertoire_No##PreserveSingleQuotes(QryAgendaActif)#and date_fin >= #CreateODBCDate("#now()#")#
ORDER BY niveau5 desc, date_debut
SELECT Titre,Extrait,Description
FROM Activites
WHERE Id=#agenda.Source_Id#
SELECT titre,extrait,description
FROM sections_pages
WHERE Id=#agenda.pageid#