Index: openacs-4/packages/dotlrn/www/admin/class.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/class.xql,v diff -u -N -r1.13 -r1.14 --- openacs-4/packages/dotlrn/www/admin/class.xql 22 Nov 2017 13:36:41 -0000 1.13 +++ openacs-4/packages/dotlrn/www/admin/class.xql 22 Nov 2017 13:37:48 -0000 1.14 @@ -106,8 +106,8 @@ select dotlrn_terms.term_name || ' ' || dotlrn_terms.term_year, dotlrn_terms.term_id from dotlrn_terms - where dotlrn_terms.end_date > current_date - 360) - and dotlrn_terms.start_date < current_date + 360) + where dotlrn_terms.end_date > (current_date - 360) + and dotlrn_terms.start_date < (current_date + 360) order by dotlrn_terms.start_date, dotlrn_terms.end_date