Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-users@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of gcaiou-ooo-users@m.gmane.org
 designates 80.91.229.3 as permitted sender)
To: ooo-users@incubator.apache.org
From: Alex Thurgood <alex.thurgood@gmail.com>
Subject: Re: Dates changed on entry in database
Date: Fri, 29 Jun 2012 10:08:02 +0200
Lines: 40
Message-ID: <jsjnou$qa9$1@dough.gmane.org>
References: <4FEBDB63.4090509@dreamchaser.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:13.0) Gecko/20120615 Thunderbird/13.0.1
In-Reply-To: <4FEBDB63.4090509@dreamchaser.org>

On 28/06/2012 06:19, Gary Aitken wrote:

Hi Gary,

> I have a form connected to a mysql database with a datetime field.
> The first time I enter a date for a new record, with the time portion of the field still empty, the day is changed to be one day less.  For example, if I enter 2012-06-27 the date is reformatted and changed to 06/26/12.  If I then clear out the date and time, and enter the time, the date is set to 01/01/1800.

The offset is an old, old bug that has haunted OOo for years and raises 
its ugly head on a regular basis, then gets forgotten about (or the bug 
report dismissed), as it doesn't always seem to be reproducible. In the 
past, I've opened at least one I can definitely remember, but possibly 2 
or 3 bug reports for this terrible behaviour, but each time they were 
closed as unreproducible. There was also a discussion somewhere on the 
dba OOo mailing lists at one stage, but I guess that could only be found 
now by trawling the archives of those lists.


> If I then try to change the date by deleting it and entering 2012-06-27 again, it always resets to 01/01/1800.  What's going on?
>
> Also, how do I change the default date display for everything in OO as a whole?

Under Tools > Options, you can set date handling for Calc, but 
unfortunately the different modules use different datetime 
routines/functions for the handling of dates, which is possibly one of 
the reasons why these problems occur. Another more basic reason might be 
rounding errors in date calculation within OOo, but I don't know where 
that could be found in the source code.


>
> Or if that's not possible, how do I change the date display for a datetime field in a base form?  I tried ungrouping the label + datetime field, then ungrouping the datetime field, then doing Format but everything is greyed out.

If you are in Form design mode, then you should be able to access the 
form's controls properties by right mouse button clicking on a field 
control representing the bound data field, and then setting its 
"properties" from the context menu. If you can't do this, then either 
your form is not properly bound to the underlying data, or else it is a bug.


Alex


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org