~[wc:commonscripts] ~[wc:admin_header_css] ~[wc:admin_navigation_css]

Today's Bus Notes - ~[short.date]

~[tlist_sql; SELECT s.last_name last_name, s.first_name first_name,s.home_room, bn.note note, bn.no_days no_days, to_char(bn.start_date,'mm/dd/yyyy') start_date, to_char(bn.end_date,'mm/dd/yyyy') end_date FROM U_BUS_NOTES bn JOIN students s ON bn.studentsdcid = s.dcid WHERE s.schoolid = ~(curschoolid) AND trunc(sysdate) BETWEEN bn.start_date AND bn.end_date ORDER BY s.last_name, bn.start_date desc ;nonemessage=] [/tlist_sql]
Last Name First Name Home Room Note Number of Days Start Date End Date
No Bus Notes Found
~(last_name) ~(first_name) ~(home_room) ~(note) ~(no_days) ~(start_date) ~(end_date)
~[wc:admin_footer_css]