I am trying to create a query that tells me how many days each student was present in a specific class. I was able to run a query that gave me when each student entered the class and when they left but I would like to not have to calculate the number of days myself.
This is the query LIST STU CAR CAR.CN CAR.PD CAR.SE CAR.DS CAR.DE IF CAR.CN >= 8013 AND CAR.CN<= 8092
This gave me the start and end date each student was enrolled in the class but can I add something to it to calculate how many days that is? Or is there a better report to use?