OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Between dates

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
stanleywj
General User
General User


Joined: 28 Oct 2003
Posts: 11

PostPosted: Wed Nov 12, 2003 4:55 pm    Post subject: Between dates Reply with quote

Each record of a small dBase database has a "Date" field. How would i create a query that searches "between" 2 specified dates. As an alternative, is it possible to just search for all records in *specified month*?

Got data in, just gotta get it out in a useful way

Many thanks Very Happy
Back to top
View user's profile Send private message
pcwizard_01
Guest





PostPosted: Wed Nov 19, 2003 10:42 am    Post subject: Between Dates Reply with quote

You should be able to do a logical <= one field and >= another. My question is, how does one get the current system date? I haven't been able to get the sysdate function to work.
Back to top
pcwizard_01
Newbie
Newbie


Joined: 19 Nov 2003
Posts: 1
Location: Rochester NY

PostPosted: Wed Nov 19, 2003 10:49 am    Post subject: Re: Between Dates Reply with quote

pcwizard_01 wrote:
You should be able to do a logical <= one field and >= another. My question is, how does one get the current system date? I haven't been able to get the sysdate function to work.


In addendum, I actially need to compare a date col to the current system date, but it keeps telling me that I cannot compare the col with a date. I should note I am using a Oracle 8i dbase with jdbc
Back to top
View user's profile Send private message
stanleywj
General User
General User


Joined: 28 Oct 2003
Posts: 11

PostPosted: Wed Nov 19, 2003 3:39 pm    Post subject: now using access..... Reply with quote

Thanks for the reply, i have to admit I've given up on trying to get "results" from this method. I'm now only using this method(dBase) for collection of data. I'm opening the dbf in M$ Excel/Calc and exporting as excel file. Then using Access i can get my Logical Criterion to work "reliably". It's still early days for OO, i'm not gonna give up on it.

As for System date, some of my dBase data sources seem to utilise the current date automatically if the "date" type is relected for a column, but not all the time Sad. Oracle is a long way from where i sit in the scheme of things. [/u]
Back to top
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Thu Nov 20, 2003 6:54 am    Post subject: Reply with quote

I used the Criterion " > #01/03/2003# AND < #01/07/2003# " on my Date field and got records for 01/04/03 through 01/06/03. (OO provided the "#"s and uppercased my "and".) Basically this is what was suggested before. Is there a reason it doesn't work for you?
Back to top
View user's profile Send private message
stanleywj
General User
General User


Joined: 28 Oct 2003
Posts: 11

PostPosted: Wed Dec 03, 2003 6:23 pm    Post subject: tweening dates Reply with quote

Now working, i've had funny things like this happen to me before with OOo. Hope it holds together, many thanks for the assistance ppl.

Cheers
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group