Problem In Time Zone

einspire · Post by **einspire** » Thu Feb 14, 2008 6:05 am

I am just a begginer with TimeTrex and I am facing strange time mismatch problem: punching at 9:00 AM to 6:00 PM is recorded as 4:30 AM to 12:30 PM in Timesheet Report. I played a lot with settings but couldn't get any clue what could be the reason for this shift. The user manual appears to be helpless to me as well.

I have installed Time Trex Standard edition – Version 1.5.0. The installation was successful. I added employee’s details. I have set the Time to IST in the Menu / My Account / Preferences but still the problem persists.

For You Info: The Database is PostgreSQL & Operating System is Windows Server 2003,

Please help.

Post by **shaunw** » Thu Feb 14, 2008 11:31 am

TimeTrex v1.5.0 is probably over a year old, please install the latest version of TimeTrex (v2.2.5) and try again.

Chances are the issue has to do with your timezones under MyAccount -> Preferences, but you will definitely want to upgrade to the latest version first.

einspire · Post by **einspire** » Fri Feb 15, 2008 12:22 am

IS there a cure for this in the same version.

Post by **shaunw** » Fri Feb 15, 2008 9:06 am

You can try using one of the Etc/GMT... time zones to see if those help. Regardless though it is extremely important that you upgrade to the latest version.

einspire · Post by **einspire** » Fri Feb 15, 2008 9:01 pm

I tried installing the latest version of TimeTrex (v2.2.5) but the problem is not solved.

Post by **shaunw** » Mon Feb 18, 2008 9:27 am

Did you try using one of the: Etc/GMT* timezones?

einspire · Post by **einspire** » Tue Feb 19, 2008 5:38 am

Yes I tried, it didn't work. Available are GMT 5 or GMT 6, as India is GMT 5:30 I would need that.

Post by **shaunw** » Tue Feb 19, 2008 1:23 pm

Unfortunately it looks like PostgreSQL doesn't support the IST timezone. You will need to try MySQL instead.

einspire · Post by **einspire** » Tue Feb 19, 2008 9:07 pm

Where do I get MySQL and should I install the TimeTrex application again.

Post by **shaunw** » Wed Feb 20, 2008 10:47 am

You can download MySQL from:
http://www.mysql.com/

You don't need to install TimeTrex again, but you will lose any data that you have in its database.

einspire · Post by **einspire** » Wed Feb 20, 2008 10:57 pm

CAN I USE MICROSOFT SQLSERVER INSTEAD MYSQL

Post by **shaunw** » Thu Feb 21, 2008 9:44 am

TimeTrex only supports PostgreSQL, EnterpriseDB or MySQL at this time.

Post by **shaunw** » Wed Aug 13, 2008 3:04 pm

This thread may help solve the issue:
http://forums.timetrex.com/viewtopic.php?p=4084#4084

TimeTrex Time and Attendance