Originally Posted by Fou-Lu
$dtEnd must be exclusive on dateperiod.
Add this directly before the datePeriod creation:
As for your data, I myself would probably track the absentee. Assuming that there is specific guidelines to follow that dictate when a day should be in attendance, then recording only those absent would reduce the amount of dataspace required. This of course assumes that on average the majority of the student population is present and not absent.
Ok Fou-Lu I tried it out but facing some problems still. Will try my best to rectify it else will come back