server/client date issue

Classic Servoy
1

I have an issue whereby the clients logging in to a solution are seeing a different date (by one day) in fields that they have put the correct date in. When I query the database I see the correct dates are actually in the date fields. If I restart that server (it’s a PC running XP) then the dates show up correctly. Using developer I have the locale/timezone set correctly to the local timezone (which all users are in). In looking at the Servoy admin pages I see the a user is logged in with these time settings:

User logged in: Tue Mar 22 21:51:43 UTC 2011
Solution opened: Tue Mar 22 21:51:43 UTC 2011
User idle since: Wed Mar 23 19:30:45 UTC 2011

I’m presuming from this that the server is using UTC time (either the PC itself or Servoy server) and thus the client when logged in gets this one day discrepancy. In searching the docs I only find ‘UTC’ under i18. And I can’t see any setting on the server admin pages controlling that.
Currently I’m running Servoy 3.5.12 but I’m about to move to Servoy 5 and will be setting up a remote Servoy server on a Linux box so want to make sure I don’t have this problem. Can anyone tell me if where this problem lies and how to fix it? (If it’s a PC thing I’ve only checked the Settings/Control Panel/Date Time but that seems correctly set to our local time zone.)

2

The server just gets it from the system it is on.
You can view this in the admin page server information: current time, that displays most of the time as far as i know the timezone it is in.

Also when using different timezone’s this property: servoy.use.client.timezone should really be to true… (but i don’t remember from the top of my head if 3.5 already had this)

Besides that there are quite some date/timezone fixes between 3.5 and now 5.2 so an upgrade also could fix your problem.