[users] Re: [openoffice] Re: [users] Dates in Base

2009-06-01 Thread Keith Bates
On Mon, 2009-06-01 at 21:51 +0200, Franz Wein wrote: > Hi Keith > > This is a problem in nearly all database - systems - my solution - use a > date of death for all your fishes for example the 31.12.2999 - normaly > this date ist possilbe in all database. If a fish died - fill in the day > of

Re: [users] Re: [openoffice] Re: [users] Dates in Base

2009-05-31 Thread Keith Bates
On Sun, 2009-05-31 at 10:08 -0400, Drew Jensen wrote: > >> > > > > Thanks Drew, but that comes up as an invalid SQL expression > > > > I've also tried <#11/1/1958# but that just returns an empty set. > > > > > Sorry forgot a small bit there...my mistake... > > IS EMPTY > > > > -

Re: [users] Re: [openoffice] Re: [users] Dates in Base

2009-05-31 Thread Drew Jensen
Thanks Drew, but that comes up as an invalid SQL expression I've also tried <#11/1/1958# but that just returns an empty set. Sorry forgot a small bit there...my mistake... IS EMPTY - To unsubscribe, e-mail: users-uns

[users] Re: [openoffice] Re: [users] Dates in Base

2009-05-31 Thread Keith Bates
On Sun, 2009-05-31 at 06:41 -0400, Drew Jensen wrote: > Keith Bates wrote: > > I have a database table where I keep details of the fish in my tank. > > > > One of the fields is the date when the fish died. > > > > I want to make a list of currently living fish by searching for records > > where