To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=50910
------- Additional comments from [EMAIL PROTECTED] Thu Apr 27 07:32:09 -0700
2006 -------
Well, as I said in the first description of my problem, I have difficulties
using the BETWEEN statement in conjunction with dates.
When using the usual notation for dates
BETWEEN #01/01/2004# AND #12/31/2004#
I get a syntax error.
Using the notation
BETWEEN '#01/01/2004#' AND '#12/31/2001#'
I can switch from the design view to the SQL view, but running the query gives
SQL Status: 22008
Error code: 1858
ORA-01858: a non-numeric character was found where a
numeric was expected
Entering the correct SQL statement directly in SQL view
BETWEEN {D '2004-01-01'} AND {D '2004-12-31'}
works fine for the query but when switching to design view, it is
translated back to
BETWEEN #01/01/2004# AND #12/31/2004#
and the trouble starts from scratch.
Using the work around you suggested
BETWEEN '2004-01-01' AND '2004-12-31'
results in the error message
SQL Status: 22008
Error code: 1861
ORA-01861: literal does not match format string
and is thus not useable for me.
I hope this helps you to localise the source of the problem.
Please let me know, if I can give any other help.
Hans
---------------------------------------------------------------------
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]
