Issue 66900 - Date to Fields Date rolled back -2 days
Summary: Date to Fields Date rolled back -2 days
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2006-06-30 17:22 UTC by johnpawlicki
Modified: 2013-08-07 15:45 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description johnpawlicki 2006-06-30 17:22:34 UTC 
I have "Date" field - when I do a Data to Field the date rolls back by -2 days.
However data to text the date is correct.

Same problem was there with 2.02

John Pawlicki
Comment 1 Regina Henschel 2006-06-30 21:34:34 UTC 
What kind of database do you use? Calc-table, dBase, embedded HSQL, MySQL, ...?
Comment 2 Frank Schönheit 2006-07-05 11:33:25 UTC 
Cannot reproduce. Please consider
http://qa.openoffice.org/issue_handling/basic_rules.html#reproducibility. Thanks :)
Comment 3 christoph.lukasiak 2006-08-28 11:46:07 UTC 
no repro
Comment 4 christoph.lukasiak 2006-08-28 11:46:45 UTC 
no respond => close
Comment 5 openoffice 2012-06-30 04:51:07 UTC 
I would like to reopen this bug but don't see how.  If it isn't reopened, I'll end up filing a new bug.  

This is totally reproducable in my situation.

AOO 3.4.0 build 9590 running FreeBSD 9.0
Using a MySql backend

I have a db with a field of type datetime.
Using the oo form wizard, I created a form.

If I open the form to enter a new record in the db and type a date of the form:
"2012-06-29" it is displayed rolled back one day, as "06/28/12".  If I then clear out the date and time, and enter the time, the date is set to 01/01/1800 and stays there; attempts to change it always reset to 01/01/1800.

The form field connected to the datetime field has a control with a label and a control.  Ungrouping gets the datetime control separate from the label.  Ungrouping again allows one to see the properties of the date portion of the control.  The date portion has a format of "Standard (Short)".

If the date format is changed to "YYYY-MM-DD" the problem goes away.