RT saves dates in the DB in UTC. In the web interface dates are displayed based on the RT_SiteConfig.pm [1] or User timezone.
Maybe just your timezone config is wrong. Chris [1] http://bestpractical.com/docs/rt/latest/RT_Config.html#Timezone Am 20.11.2014 um 15:17 schrieb Bryon Baker: > Thanks for your response Christian. > > So where it RT is that configuration? > > This is why I developed the script to update the resolved date and > timeworked. I have been trying to get this to work for months and I have > completely missed the configuration you are talking about. > > Thanks > Bryon Baker > Network Operations Manager > Copesan - Specialists in Pest Solutions > 800-267-3726 . 262-783-6261 ext. 2296 > bba...@copesan.com > www.copesan.com > "Servicing North America with Local Care" > > -----Original Message----- > From: Christian Loos [mailto:cl...@netcologne.de] > Sent: Thursday, November 20, 2014 1:52 AM > To: Bryon Baker; RT Users (rt-users@lists.bestpractical.com) > Subject: Re: Problem with date > > Hi, > > as far as I understand you script you try to set the ticket resolved date to > the transaction date when the ticket status is set to closed. > > If you have configured you RT correct this is done automatically by RT. > > So what is your intent with this script? > > Chris > > Am 19.11.2014 um 20:18 schrieb Bryon Baker: >> I am attempting use the following code to update the Resolved date in >> a ticket. Thanks for the help in advance. >> >> >> >> package RT::Action::CSRUpdateResolvedTest; >> >> use base 'RT::Action'; >> >> use strict; >> >> use warnings; >> >> >> >> sub Prepare >> >> { >> >> return 1; >> >> } >> >> >> >> sub Commit >> >> { >> >> >> >> my %mon2num = qw( >> >> jan 1 feb 2 mar 3 apr 4 may 5 jun >> 6 >> >> jul 7 aug 8 sep 9 oct 10 nov 11 dec >> 12 >> >> ); >> >> my $self = shift; >> >> my $ticket = $self->TicketObj; >> >> my $datecreated = $ticket->CreatedObj->Unix; >> >> my $dateupdated = $ticket->LastUpdatedObj->Unix; >> >> my $datecreatedstr = $ticket->CreatedObj->AsString; >> >> my $dateupdatedstr = $ticket->LastUpdatedObj->AsString; >> >> my $dateresolved; >> >> my $dateresolvedstr; >> >> my @dateresolvedstr; >> >> my $transactions = $ticket->Transactions; >> >> $transactions->Limit( FIELD => 'Type', VALUE => >> 'Status', FIELD => 'NewValue', VALUE => 'closed'); >> >> while (my $transaction = $transactions->Next) >> >> { >> >> $dateresolved = localtime($transaction->CreatedObj->Unix); >> >> @dateresolvedstr = split(" >> ",$dateresolved); >> >> $dateresolvedstr = $dateresolvedstr[4] . "-" >> . $mon2num{lc substr($dateresolvedstr[1], 0, 3)} . "-" . >> $dateresolvedstr[2] . " " . $dateresolvedstr[3]; >> >> } >> >> >> >> print $dateresolvedstr . " " . $dateresolved . "\n"; >> >> $ticket->SetResolved($dateresolvedstr); >> >> >> >> return 1; >> >> } >> >> >> >> The dates printed to the console are correct but when I view the >> ticket the resolved date is different than the dates printed to the >> console by >> 6 hours. This seems to me to be the off set for the time zone. What >> do I need to add for Request Tracker to take the date as is? >> >> >> >> Thanks >> >> Bryon Baker >> >> Network Operations Manager >> >> */Copesan/**/- Specialists in Pest Solutions/* >> >> 800-267-3726 . 262-783-6261 ext. 2296 >> >> bba...@copesan.com <mailto:cstep...@copesan.com> >> >> www.copesan.com <http://www.copesan.com/> >> >> */"Servicing North America with Local Care"/* >> >> >> > >
