Attendance Enrollment records cannot contain a non school day date. This query will find students that have Attendance Enrollment records for Enters, Leaves, or Both that were entered on a non-school day date.

LIST STU ATT DAY STU.ID STU.NM STU.GR ATT.DY ATT.CD ATT.DT DAY.DT DAY.DY DAY.HO IF ( ATT.CD = E OR ATT.CD = L OR ATT.CD = B ) AND DAY.HO # " " AND DAY.HO # "%"

If the school is set up for Tracks, run the following query

LIST STU ATT DAY STU.ID STU.NM STU.GR ATT.DY ATT.CD ATT.TR ATT.DT DAY.DT DAY.DY DAY.T1 DAY.T2 DAY.T3 DAY.T4 DAY.T6 DAY.T7 DAY.T8 DAY.T9 DAY.T11 DAY.T12 IF ( ATT.CD = E OR ATT.CD = L OR ATT.CD = B ) AND ( ( ATT.TR = A AND DAY.T1 # " " AND DAY.T1 # "%" ) OR ( ATT.TR = B AND DAY.T2 # " " AND DAY.T2 # "%" ) OR ( ATT.TR = C AND DAY.T3 # " " AND DAY.T3 # "%" ) OR ( ATT.TR = D AND DAY.T4 # " " AND DAY.T4 # "%" ) OR ( ATT.TR = E AND DAY.T5 # " " AND DAY.T5 # "%" ) OR ( ATT.TR = F AND DAY.T6 # " " AND DAY.T6 # "%" ) OR ( ATT.TR = G AND DAY.T7 # " " AND DAY.T7 # "%" ) OR ( ATT.TR = H AND DAY.T8 # " " AND DAY.T8 # "%" ) ) 

Query Translation Key for Attendance Tracks:

A = 1

B = 2

C = 3

D = 4

E = 5

F = 6

G = 7

H = 8