= #CreateODBCDate("#now()#")# AND date_debut <= #CreateODBCDate("#DateAdd("d","#NoDay#","#now()#")#")#"> = {d '#attributes.jour#'} AND date_debut <= #DateDure#"> SELECT Id, Personne, Actif, Web, Presentateur, Activite, Description, Domaine, Nature, Lieu, Ville, Province, Information, date_debut, date_fin,DB_Source FROM Agenda3 WHERE Langue LIKE '%fr%'#PreserveSingleQuotes(Var.QUERY)# AND (Repertoire_No=#attributes.Repertoire_No# OR DB_Source='#attributes.Repertoire_No#') AND (Actif='1' or Actif='3' or Actif='4') ORDER BY date_debut
#countresult# activité(s) répertoriée(s) en #lsDateFormat("#date#", "mmmm yyyy")#

#output.Activite# #output.Activite#

Du #DateFormat("#output.date_debut#","dd")# #lsDateFormat("#output.date_debut#","mmmm")# #DateFormat("#output.date_debut#","yyyy")# au #DateFormat("#output.date_fin#","dd")# #lsDateFormat("#output.date_fin#","mmmm")# #DateFormat("#output.date_fin#","yyyy")# #output.Ville# - #output.Lieu# #Replace("#Left("#output.Description#",150)#","#chr(13)##chr(10)#"," ","ALL")#... détails >>>