Index: openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql 18 Nov 2001 18:57:58 -0000 1.1 +++ openacs-4/packages/edit-this-page/templates/news-index-postgresql.xql 18 Dec 2001 19:28:00 -0000 1.2 @@ -4,20 +4,20 @@ - current_timestamp between to_date(attributes.release_date, 'YYYY-MM-DD') and - to_date(attributes.archive_date, 'YYYY-MM-DD') + current_timestamp between to_date(attributes.release_date, 'Month DD, YYYY') and + to_date(attributes.archive_date, 'Month DD, YYYY') - current_timestamp >= to_date(attributes.archive_date, 'YYYY-MM-DD') + current_timestamp >= to_date(attributes.archive_date, 'Month DD, YYYY') - to_date(attributes.release_date, 'YYYY-MM-DD') desc + to_date(attributes.release_date, 'Month DD, YYYY') desc