To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95443 Issue #|95443 Summary|changing a field in a table to date format fails if it |'s not empy Component|Database access Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|sladivadi
------- Additional comments from [EMAIL PROTECTED] Sat Oct 25 17:57:27 +0000 2008 ------- create a new database create a table in (design view) create an id field create a data field and change format to DATE create a data field and leave format as VARCHAR open the save table again and enter the same dates in the fields (02.02.02 in text and 2-2-2 in the date formatted field) save, close and edit the table and try to change the VARCHAR field to DATE saving fails because it can't change the field type to DATE Regards, Sladi --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]