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

#LSDateFormat(output.date_debut,'Dddd d')# #lsDateFormat("#output.date_debut#","mmm")# #DateFormat("#output.date_debut#","yy")# : #output.Titre# #description#