On Sun November 20 2005 05:31, Shane D wrote:
> I'm using OOo 2.0 on an XP SP1 box.
>
> I have an SQL function written (shown below) that works perfectly.
>
> SELECT First, Last, Email, Expiration
> FROM members INNER JOIN membership ON members.MembershipID =
> membership.MembershipID
> WHERE Trial = 'false'
> AND Courtesy = 'false'
> AND DATEDIFF('day', CURRENT_DATE, Expiration) > -90
> AND Email <> ''
> ORDER BY Last, First
>
> (The DATEDIFF() function is an HSQL function that subtracts two
> dates; HSQL doesn't support arithmetic on dates as far as I can tell.)
>
> But I couldn't find a way to save, copy, or otherwise store the SQL
> query results out of Base.
>
> So I decided to link the SQL query into a report via the Report
> Wizard. But it complained about not being able to read the column names
> from the query file. Indeed, it didn't show any column names in the
> selection list.
>
> Then I thought about abandoning my SQL statement and creating a query
> through the Query Builder using my clever DATEDIFF() function in a
> Criteria field for 'Expiration'. But when I do this, the Query Builder
> complains that I didn't enter a properly formatted DATE value.
> DATEDIFF() returns an integer, so my criteria is correct.
>
> I'm now out of ideas. Does anyone know a way to get any one of these
> options to work?
Hi Shane,
Since you do not seem to have received a response, you could ask on
[email protected] and ask to be CC:ed as you may not see all replies
unless you subscribe to that list by sending an email to
[EMAIL PROTECTED] and reply to the confirmation request
email.
--
CPH : openoffice.org contributor
Maybe your question has been answered already?
http://user-faq.openoffice.org/#FAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
