logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
mdumenil  
#1 Posted : Thursday, September 3, 2020 9:01:22 AM(UTC)
mdumenil

Rank: Newbie

Groups: Registered
Joined: 8/27/2020(UTC)
Posts: 7
France, Metropolitan

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é.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.