Auto enter Date/Time problem

Classic Servoy
1

I have a table with a ‘Date Modified’ field. The dataprovider is set to auto enter the date/time into this field.

When this field is populated it is showing 12 hours behind the local time.
For example the PC time is 15.40, but the field is populated with 03.40. The Servoy preferences are set to the correct locale and time zone, as is my PC (and therefore the server).

Selecting Modification Server Datetime rather than Modification Datetime in the dataproviders does not change this.

Any ideas?

Version 3.1.6-build 410
Java version 1.5.0_10-b03 (Windows XP)
MySQL 5

2

Are you sure it is 12 hrs behind? Isn’t it more 12hrs display instead of 24hrs.

3

I’ll take a look at the field format, thanks for the suggestion.