I have this error when i execute the query. this error seems to concern the field Absences.Date_Fin
10:57:03 Error in model 'Model': Unexpected error when executing the following SQL statement:
SELECT DISTINCT
Absences.No_Patient AS C0,
Absences.No_Fiche AS C1,
Absences.Motif_Absence AS C2,
Absences.Notes AS C3,
Absences.Valide AS C4,
Absences.Heure_Depart AS C5,
Absences.Heure_Retour AS C6,
Absences.Retour_valide AS C7,
Absences.Utilisateur AS C8,
Absences.Info AS C9,
Absences.Transport AS C10,
Absences.Ambulancier AS C11,
Absences.ID_REP AS C12,
Absences.Accord_Med AS C13,
Absences.Accord_Info AS C14,
Absences.Classe_KM_ST AS C15,
Absences.Facturation_Transport AS C16,
Absences.Archive AS C17,
Absences.Date_Debut AS C18,
Absences.Date_Fin AS C19
FROM Absences
ORDER BY Absences.No_Patient ASC,Absences.No_Fiche ASC,Absences.Transport ASC,Absences.Ambulancier ASC,Absences.ID_REP ASC,Absences.Accord_Med ASC,Absences.Accord_Info ASC,Absences.Classe_KM_ST ASC,Absences.Facturation_Transport ASC,Absences.Archive ASC,Absences.Date_Debut ASC,Absences.Date_Fin ASC,Absences.Motif_Absence ASC,Absences.Notes ASC,Absences.Valide ASC,Absences.Heure_Depart ASC,Absences.Heure_Retour ASC,Absences.Retour_valide ASC,Absences.Utilisateur ASC,Absences.Info ASC
Error detail:
Les paramètres Year, Month et Day décrivent un DateTime qui ne peut pas être représenté.