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 [email protected] On 21 February 2013 22:16, Alex Thurgood <[email protected]> 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: [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/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- For unsubscribe instructions 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/users/ All messages sent to this list will be publicly archived and cannot be deleted
