Version: 1.6.3 (using KDE 3.5.8) Installed from: Gentoo Packages OS: Linux In my case the locale is sl_SI.utf8 (i.e. Slovenian), but I suspect it's a global bug. When I enter date fields in tables I can only use the locale format (i.e. dd.mm.yy), but although one would expect the same format to be used in the queries, it is not the case. The only one when writing queries that worked for me was the ISO format (i.e. yyyy-mm-dd). What I would expect: * coherent use of one (perferably locale) format in both table input and queries
I suspect this is also the reason why using KexiReportPart (0.0.4) shows dates in the report in the ISO format.
Its probably not fair to put this as a bug against Kexi as my report part is a seperate project. Its also in quite an infant stage, but i#ll do my best to fix reported bugs. I'll also reply to your other email later.
No, no. I've noticed the bug even before I used your KexiReportPart. I found that bug with the help of ingwa, SaroEngels, astan (and others) on the #koffice IRC channel when I was just trying to write a query that would show me only entries that are dated on a specific month.
The ISO format yyyy-mm-dd is used i nthe SQL language, especially in facilities behind the designer, namely SQL parser. We could support locale formats but need to find out a way to indicate a data constant is in locale format -- a way that can be considered as a standard. So - later, plese remind for Kexi 2.x.
Will do ;)