Issue 118010 - Cannot assign "02.04.1945" to Date (Win7, german)
Summary: Cannot assign "02.04.1945" to Date (Win7, german)
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO330m20
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://user.services.openoffice.org/e...
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-13 08:01 UTC by thomas
Modified: 2013-01-29 21:47 UTC (History)
2 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 thomas 2011-05-13 08:01:20 UTC 
In OpenOffice.org Basic

Dim MyDate As Date
MyDate = "2.4.1945"

throws an error "wrong value or datatype: datatype incompatible".

It is reproducible with 
Win 7 Pro SP1 German OOO330m20
Win 7 Home Premium SP1 OOO320m18
Win 7 LibreOffice

Other dates should work like expected
Comment 1 thomas 2011-05-13 08:29:58 UTC 
testes with the following code, "02.04.1945" is the only failure with Integer I = 16529

Sub Main
	Dim I
	Dim MyDate As Date
	Dim Test As String
	On Error Goto ErrorHandler
	For I = 1 To 41000 Step 1 '41000
		MyDate = I
		Test = MyDate
		MyDate = Test
	Next I
	Exit Sub
	ErrorHandler:
		msgbox I
End Sub

mybe this is useful:
wikipedia tells, that "02.04.1945" was the beginning of summertime in germany, but ended on different dates in west and ost-germany
Comment 2 r4zoli 2011-05-13 08:44:46 UTC 
Please test in OOo 3.4 beta.
Comment 3 thomas 2011-05-13 10:35:52 UTC 
same error on:
Win 7 Pro SP1 German OOO340m0 (with and without German language pack)
Comment 4 r4zoli 2011-05-13 10:54:56 UTC 
Added link to OOo user forum post.
Removed target, it can not be set until developer not start working on it.

May be needs to redirect to framework, it is more a StarBasic problem than database bug, but I'm not sure.
Comment 5 Oliver-Rainer Wittmann 2012-06-13 12:31:06 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.