Apache OpenOffice (AOO) Bugzilla – Issue 18758
Prompted Querys should always accept unambigious Date/Time formats (ISO notation)
Last modified: 2006-05-31 14:29:06 UTC
This issue arose from Issue 18594 where the responder indicated that this should be considered as an enhancement. When prompted for Date/Time variables, the parser should be prepared to accept unambigious input for Date/Time fields reguardless of the Locale. For example, the string: <digit><digit><digit><digit><delimiter>[<digit>]<digit><delimeter>[<digit>] <digit> can always (I think but don't really know) be safely parsed as YYYY/MM/DD.
Jeffery, thanks for filing this. The notation you refer to (YYYY-MM-DD) is know as ISO notation :) - adding this to the summary fs->oj: This is related to the internal bug 109202 - but neither of the two is a real duplicate of the other one. re-assigning, confirming, targeting
noticed a little bit too late that you talked about a general delimiter, not only '-'. I am uncertain if this would be a good idea, since I don't know the relevance of other delimiters 'd' in a YYYYdMMdDD notation. E.g. (correct me if I'm wrong) the usual format for the english-us locale is DD/MM/YYYY - is YYYY/MM/DD really used? Furthermore, there may be locales (I don't know, but OOo supports such a huge amount of them, that we cannot be sure :) where the *default* notation would be YYYY.DD.MM - who knows? In such a locale, accepting YYYY.MM.DD would be disastrous. IOW, I tend to saying we should accept the ISO notation, but not arbitrary delimiters, as we maybe cannot guarantee that this is unambiguous in all locales.
For english locales the format is MM/DD/YYYY.
Well, I certainly am not going to speak for the entire English speaking world. :-) But here in the USA MM/DD/YYYY is the common format, two digit year with leading zeros ommited for MM and DD being the most common. But the YYYY/MM/DD format is also seen frequently. I agree with your example and conclusion and will be happy with a solution that allows ISO formats. Thanks, Jeff
The parser now accepts also the ISO format YYYY-MM-DD. If you want this to work in your current installtion, you have to select your table in the broser (F4) and change the format of the date column (right mousr click on header) to ISO. After that, you can enter ISO format into the query design. Fixed in CWS oj07 Best regards, Ocke
change subcomponent to 'none'
.
verify in cws oj07
Hi, fixed in current developer build -> close. The current developer build can be found at http://download.openoffice.org/680/index.html Feel free to reopen if this issue is not fixed in the developer build. Bye Marc