dbbeneficiaryattendance.CLEAR_WHERE
dbbeneficiaryattendance.ADD_WHERE_STRING("programmeid", "=", programmeid)
dbbeneficiaryattendance.ADD_WHERE_STRING("checkindate.start", ">=", sstartdate)
dbbeneficiaryattendance.ADD_WHERE_STRING("checkindate.end", "<=", senddate)
banano.Await(dbbeneficiaryattendance.SELECT_WHERE1)