On 26/10/14 20:57, Robert Großkopf wrote:
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 thi
Hi :)
Sounds like you have done a fantastic job! Many thanks for sorting all
that out. You've done considerably more than your fair share already so
don't worry if you are not able to continue for a while. Good luck with
the connection though! I hope it gets sorted out soon!!
Many thanks and re
I have uploaded this into the feedback folder. I am having some connection
problems at the moment so I may not be able to do so much in the next few days.
--
Hazel
--
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing
Hi
Robert Großkopf wrote
> you could use something like this:
> DATEDIFF('dd','1899-12-30',TODAY)+10
+1
Robert Großkopf wrote
> 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 on
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 c