Hi Peter,
> I want to set a date range in a query to be between TODAY -10 Days and
> TODAY + 10 days. Is there a simple way to do this?
You need a function like DATEADD (MySQL/MariaDB). This function isn't
included in the HSQLDB.
The first time I tried this I created a table by using Calc. One column
a Integer, second column Date. Let Calc added all Dates up to the time I
nedded. Then I could look into this table for my date (Today), count 10
for the Integer down and look for the new date.
If you don't use the date as DATE in the HSQLDB you could use something
like this:
DATEDIFF('dd','1899-12-30',TODAY)+10
You could format the column to date and the GUI will change this to the
date you want. But remember: The format of the query will never been
saved. So it could only be usable in a form.
Regards
Robert
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted
