Re: [tdf-discuss] libreoffice base

On 26 April 2012 19:01, Philipp Weissenbacher <p.weissenbacher@gmail.com>wrote:

> Hello alekos,
> May Insugget to post this on http://ask.libreoffice.org/ ?
> This list is for general discussion on the project and not so much on
> helping individuals. You surely have a bigger chance of getting an answer
> to your question at LO Questions.
>
> Regards,
> Philipp
>
> On Thursday, 26 April 2012, Alekos wrote:
>
> > I don't find the way to filter a range of dates in the criteria of the
> > data field in a query of base ( for istance <01/01/2010 AND >31/12/2008);
> > instead the command >31/12/2008 works fine?
> > Thanks for any help
> >
> > --
> > Alekos <alexandros@slacky.it <javascript:;>>

Hi Alekos

The query you need will be something like

SELECT "ID" FROM "Test" WHERE "Date" BETWEEN {D '1945-01-01' } AND {D
'1970-12-31' }

but when you are entering the date expression in Design view or SQL view,
you can enter it like this:

BETWEEN '01-01-45' AND '31-12-70'

using the date format of your locale.  Mine is DD-MM-YY.  Yours may be
different.

Tony

-- 
Unsubscribe instructions: E-mail to discuss+help@documentfoundation.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.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted