|
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
---------------------------------------------------------------------
|
