Re: [libreoffice-users] Re: Filtering a Base Table by Data

Hi Alex,

I was using LO 3.5.6.2 working into an H2 database.  Thanks for the
suggestion, but [D:01/07/2012] didn't work either!

I think you are probably right that the filter function is broken, at least
for dates.  So I download LO 4.0, and after a lot of searching I managed to
set up the Java settings I need for H2.  (If anyone is interested its under
Tools|Options|LibreOffice|Advanced|Use Java runtime environment.)  The
dates filter worked first time!  (I entered '01/07/2012' which the system
changed to '#01/07/2012#').

So thanks a lot for pointing me in the right direction.

Noel
--
Noel Lodge
lodgemn@gmail.com


On 21 February 2013 22:16, Alex Thurgood <alex.thurgood@gmail.com> wrote:

> Le 21/02/2013 10:00, Marion & Noel Lodge a écrit :
>
> Hi Noel,
>
> > Can someone tell me what I'm missing?
>
> Not sure, but you could try :
>
> [D:01/07/2012]
>
> Which version of LO are you using ?
>
> What is your Base table's data source (embedded hsqldb, spreadsheet or
> text file, mysql, postgresql) ?
>
> Additionally, the filter functionality might just be broken. It was in
> one of the more recent versions of LO, but I can't remember which.
>
> Alex
>
>
> --
> For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
> 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/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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/users/
All messages sent to this list will be publicly archived and cannot be deleted