[rt-users] Adding SQL Function to MyTickets & MyRequests column display

[Brian McCabe]

Thanks Andy - that does exactly what I wanted!


-----Original Message-----
From: Andy Harrison [mailto:aharrison at gmail.com] 
Sent: 14 January 2005 20:59
To: brian mccabe
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Adding SQL Function to MyTickets & MyRequests column
display


On Fri, 14 Jan 2005 10:21:52 +0000 (GMT), brian mccabe <thealbs at yahoo.co.uk>
wrote:
> 
> 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