cancel
Showing results for 
Search instead for 
Did you mean: 

6.2.4 Post DST one hour offset

SOLVED
Go to solution
Highlighted
Robert Wilkinso
Super Collector

6.2.4 Post DST one hour offset

Hi,

 

We've discovered that since Daylight Savings kicked in, TRIM is now reporting the wrong times on documents registered before that. If you go back to last year's DST period, they're correct again.

It's most noticeable on emails since they show you the sent/received date when you view them, but it appears to affect other documents as well

I've checked that the time zone settings are correct and that all DST patches are installed on our TRIM server.

Our TRIM server is running 6.2.4 build 1240.

 

Date created (from TRIM): 1/04/2010 at 5:07pm

Sent (from outlook): Mon 1/04/2010 5:07pm

 

Date created (from TRIM): 6/04/2010 at 11:31am

Sent (from outlook): Tue 6/04/2010 10:31am

 

Date created (from TRIM): 1/10/2010 at 5:39pm

Sent (from outlook): Fri 1/10/2010 4:40pm

 

Date created (from TRIM): 4/10/2010 at 9:56pm

Sent (from outlook): Mon 4/10/2010 9:57pm

 

I'd appreciate any advice anyone can offer with this.

Kind Regards,

Robert Wilkinson.

2 REPLIES
Grundy
Honored Contributor
Solution

Re: 6.2.4 Post DST one hour offset

Dates/Times in TRIM are stored in a GMT string format in the database and dispalyed to the user based on a current Regional time conversion.

 

So during DST it might be +10 hours for example, but during standard time it might be +9 hours.

 

Yes, this can lead to some confusion when looking at the regional time. There is a current enhancement request open with R&D to have the regional time preserved in some way so that you can always see the 'regional' date created/registered etc.

 

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

INFORMOTION.com.au
Robert Wilkinso
Super Collector

Re: 6.2.4 Post DST one hour offset

Thanks for your quick and helpful response

:smileyhappy:

//Add this to "OnDomLoad" event