Adding SQL Function to MyTickets & MyRequests column display

RT Users
1

I have changed the MyTickets and MyRequests to replace
Priority with Due Date.

The problem I have is that th default date format is
being displayed as DAY MON HH:MM:MI YYYY which forces
the ticket display onto two lines and looks fairly
gruesome!

I have looke daround to see where I could add a SQL
date_format function priro to displaying the date and
am struggling to find where this is.

Can anyone point me in the right direction?

Thanks in advance

ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com

2

I have changed the MyTickets and MyRequests to replace
Priority with Due Date.

The problem I have is that th default date format is
being displayed as DAY MON HH:MM:MI YYYY which forces
the ticket display onto two lines and looks fairly
gruesome!

I have looke daround to see where I could add a SQL
date_format function priro to displaying the date and
am struggling to find where this is.

Can anyone point me in the right direction?

Instead of Due, I find DueRelative to be much friendlier.

Andy Harrison

3

Thanks Andy - that does exactly what I wanted!From: Andy Harrison [mailto:aharrison@gmail.com]
Sent: 14 January 2005 20:59
To: brian mccabe
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Adding SQL Function to MyTickets & MyRequests column
display