Date search results in ISO

RT Users
1

Hi;

Is there any straight simple way to convert (or get) Date fields in
searches to be in yyyy-mm-dd (same as stored in database) or dd-mm-yyyy
instead of day name of month etc … ie I would like 10:30:23 10/11/2005
or 10:30:23 2005/11/10 instead of Thu Nov 1o 10:30:23 2005
or ist possible to import it to excel in that format…

rt-3.4.4 , mod_perl2,apache2

Thanks;
Roy

2

At Thursday 11/10/2005 01:32 PM, Roy El-Hames wrote:

Hi;

Is there any straight simple way to convert (or get) Date fields in
searches to be in yyyy-mm-dd (same as stored in database) or dd-mm-yyyy
instead of day name of month etc … ie I would like 10:30:23 10/11/2005 or
10:30:23 2005/11/10 instead of Thu Nov 1o 10:30:23 2005
or ist possible to import it to excel in that format…

rt-3.4.4 , mod_perl2,apache2

Thanks;

We added a callback to do this for the Created date. Our formats are
mm/dd/yy and ISO. The callback file name is
Callbacks/xxx/Elements/RT__Ticket/ColumnMap/ColumnMap

We didn’t tweak the UI yet, so the only way to use these in our setup is to
go to the advanced search screen and type CreatedShort or CreatedISO in the
lower box that lists the result columns.

Steve

<%ARGS>
$COLUMN_MAP => undef
</%ARGS>

<%init>
$COLUMN_MAP->{‘CreatedShort’} = {
title => ‘Created’,
attribute => ‘Created’,
value => sub {
my ($date, $time) = split(’ ‘, $_[0]->CreatedObj->ISO);
my ($y, $m, $d) = split (’-', $date);

         return "$m/$d/$y";
     }
 };

$COLUMN_MAP->{‘CreatedISO’} = {
title => ‘Created’,
attribute => ‘Created’,
value => sub { return $_[0]->CreatedObj->ISO }
};

</%init>

3

Hi;

Is there any straight simple way to convert (or get) Date fields in
searches to be in yyyy-mm-dd (same as stored in database) or dd-mm-yyyy
instead of day name of month etc … ie I would like 10:30:23 10/11/2005
or 10:30:23 2005/11/10 instead of Thu Nov 1o 10:30:23 2005
or ist possible to import it to excel in that format…

I wonder if you could use RT’s localization framework to “localize” the
English date format…

4

Thanks Stephen that did the trick for me -much easier than I originaly
thought …
in addition I modified
/opt/rt3/local/html/Search/Elements/BuildFormatString
Adding the CreatedISO within “my @fields”

Roy

Stephen Turner wrote: