On 26 April 2012 19:01, Philipp Weissenbacher <p.weissenbac...@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 <alexand...@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+h...@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
