= #CreateODBCDate("#now()#")# AND date_debut <= #CreateODBCDate("#DateAdd("d","#NoDay#","#now()#")#")#"> = {d '#attributes.jour#'} AND date_debut <= #DateDure#"> SELECT Id, assistance, Actif, Web, Presentateur, Titre, Description, Domaine, Nature, Lieu, Ville, Province, Information, date_debut, date_fin,DB_Source,Source_Id,Exposant 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#