Index: openacs-4/packages/contacts/lib/contacts.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/lib/contacts.xql,v diff -u -r1.23 -r1.24 --- openacs-4/packages/contacts/lib/contacts.xql 1 Apr 2006 07:07:16 -0000 1.23 +++ openacs-4/packages/contacts/lib/contacts.xql 3 Apr 2006 17:26:22 -0000 1.24 @@ -55,7 +55,8 @@ first_names, last_name, parties.party_id, parties.email, - parties.url + parties.url, + to_char(cr.publish_date, :date_format) as publish_date from parties left join persons on (parties.party_id = persons.person_id) left join organizations on (parties.party_id = organizations.organization_id), cr_items ci, cr_revisions cr