Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
SQL query needed
0 views
Skip to first unread message
Kurt Vitengruber
Jan 21, 2000, 3:00:00 AM1/21/00
to
I need to run a query on dBase that will show me all conthist.ondate dates
that are at least x number of days old. I've used getdate() to return the
current date when GoldMine is on SQL but I'm not sure what I need in dBase.
Thanks for any help!
that are at least x number of days old. I've used getdate() to return the
current date when GoldMine is on SQL but I'm not sure what I need in dBase.
Thanks for any help!
Jose Joaquin/GM
Jan 24, 2000, 3:00:00 AM1/24/00
to
Kurt,
Unfortunately, an equivalent function to getdate() is not available for
dBASE. You would need to include the current date string in the query:
select * from conthist
where (ondate - 5) <= "01/24/00"
--
Troubleshooting Guide for Goldmine4
ftp://ftp.goldmine.com/public/manuals/gm4-trbl.pdf
(follow the link to download - requires Adobe Acrobat to read)
Jose Joaquin
GoldMine Support
Visit our online KnowledgeBase at
http://kbase.goldmine.com
Kurt Vitengruber
Jan 24, 2000, 3:00:00 AM1/24/00
to
That doesn't seem to work. I get all records that have anything in
conthist. I think the problem is that we are not evaluating ondate as an
actual date, are we?
Does this expression filter out any records by their ondate for you?
conthist. I think the problem is that we are not evaluating ondate as an
actual date, are we?
Does this expression filter out any records by their ondate for you?
0 new messages