= #CreateODBCDate("#now()#")# AND date_debut <= #CreateODBCDate("#DateAdd("d","#NoDay#","#now()#")#")#"> = {d '#attributes.jour#'} AND date_debut <= #DateDure#"> SELECT Id, assistance, Actif, niveau2,Web, Presentateur, Titre, Description, Domaine, Nature, Lieu, Ville, Province, Information, date_debut, date_fin,DB_Source,Source_Id,Exposant,Photo_mini FROM Agenda3 WHERE Langue LIKE '%fr%'#PreserveSingleQuotes(Var.QUERY)# AND (Repertoire_No=#attributes.Repertoire_No# OR DB_Source='#attributes.Repertoire_No#')#PreserveSingleQuotes(QryAgendaActif)# ORDER BY niveau5 desc,date_debut

#DateFormat("#output.date_debut#","d")# #lsDateFormat("#output.date_debut#","mmm")# #DateFormat("#output.date_debut#","yy")# - #DateFormat("#output.date_fin#","d")# #lsDateFormat("#output.date_fin#","mmm")# #DateFormat("#output.date_fin#","yy")#

#output.Titre#