| View previous topic :: View next topic |
| Author |
Message |
stanleywj
General User
Joined: 28 Oct 2003
Posts: 11
|
 Posted: Wed Nov 12, 2003 4:55 pm Post subject: Between dates |
 |
|
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  |
|
| Back to top |
|
 |
pcwizard_01
Guest
|
| Posted: Wed Nov 19, 2003 10:42 am Post subject: Between Dates |
|
|
| 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
Joined: 19 Nov 2003
Posts: 1
Location: Rochester NY
|
| Posted: Wed Nov 19, 2003 10:49 am Post subject: Re: Between Dates |
|
|
| 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 |
|
|
stanleywj
General User
Joined: 28 Oct 2003
Posts: 11
|
| Posted: Wed Nov 19, 2003 3:39 pm Post subject: now using access..... |
|
|
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  . Oracle is a long way from where i sit in the scheme of things. [/u] |
|
| Back to top |
|
|
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8984
Location: Lexinton, Kentucky, USA
|
| Posted: Thu Nov 20, 2003 6:54 am Post subject: |
|
|
| 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 |
|
|
stanleywj
General User
Joined: 28 Oct 2003
Posts: 11
|
| Posted: Wed Dec 03, 2003 6:23 pm Post subject: tweening dates |
|
|
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 |
|
|
|
