Hi Bjoern, I have noticed the same issue in RT 3.6.0. I'm not sure if I got to the bottom of it but I believe that the time recorded in the database is always GMT. When you view times and dates via the web front end, the settings in RT_SiteConfig.pm come into effect, adjusting the time for your location. However the export function always outputs data direct from the DB.
I hope there's a straightforward way to fix this because it's quite frustrating for users. Andrew Date: Tue, 02 Oct 2007 09:18:39 +0200 > From: Bjoern Schulz <[EMAIL PROTECTED]> > Subject: [rt-users] Date/Time in exported spreadsheet wrong > > > Hi list, > > we are using RT 3.6.5 RC2 and I observe the following problem. > We like to export search data to a spreadsheet, but there is a different > between the date in the web-UI and the exported data. In our case its 2 > hours. > > > Our RT_SiteConfig.pm > # $Timezone is used to convert times entered by users into GMT and back > again > # It should be set to a timezone recognized by your local unix box. > Set($Timezone , 'Europe/Berlin'); > > > > Thanks for any input! > > bjoern >
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
