Accès à leur BDD

serveur : base-3c.a26.fr
identifiant : ext_3C_waka
password : hd8[t:kpy3C/Er!,

https://3c.a26.fr/dossier/public/help/views.aspx

SELECT TOP 50 
d.RefDossier, 
d.DateJourJ, 
d.DateRMission,
DATEDIFF(DAY, d.DateJourJ, d.DateRMission) AS diff
FROM V_DOSSIER d
ORDER BY d.DateJourJ DESC;