|
Okay, I now feel stupid that it was that simple,
but relieved at the same time! Now I can figure out people based on
specific dates, but what about the other way around? Is there any way to
query for when a specific record was entered? For example, I want to know
when John Doe was put in our database.
Thank you!
----- Original Message -----
Sent: Thursday, April 04, 2002 8:32
PM
Subject: [support] RE: Add Date
You
are doing something wrong. All records get an added by and added date
automatically when you add a new record and they are not changable. A
common error in typing dates is to not use 4 digit years. Try a very simple
query that looks only for some date far enough in the past that you are sure
you have added someone after it, e.g. >1/1/2002.
I would like to do a search of our
database based on the date a record ( a new person/family) was
entered. I looked in the archive to see if anyone has asked a similar
question and I see that in March, someone did ask the exact same question I
have:
Posted by Stephen Bisk: "I would like to create a query which would include the
date a record was first entered, but we have not been recording this info
(I want to find people that have not given since 1/1/98, but have been on
the mailing list for at least that time). Is there, by any chance, a field
which stamps automatically the date the
record was first entered? Any
suggestions?"
Carl Paulsen replied, "Try Add Date,
displayed in the Query routine. That does what you want.
Click on the
Query button (which starts a Find script) and enter your range on the first
screen of the query. Then you can enter 0 or a blank field for contributions
and/or dues. Then execute the find."
Well, I tried this and it did not
work. It says that no records can be found matching that
criteria. Is that becasue we have never tracked when a new person was
entered into the database? Or am I doing something
wrong?
Thanks, Kathleen
Kathleen Ackley
Development
Director
Hells Canyon Preservation Council
541-318-5963
www.hellscanyon.org ------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the
email address you used to subscribe to the ebase support list::
[EMAIL PROTECTED] To unsubscribe send a blank email to
[EMAIL PROTECTED]
--------------------------------------------------------------------- ebase
- Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
------------------ Reminder to each recipient: To change your
list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email
address you used to subscribe to the ebase support list::
[EMAIL PROTECTED] To unsubscribe send a blank email to
[EMAIL PROTECTED]
--------------------------------------------------------------------- ebase -
Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
|
