|
As
delivered the ADD DATE and ADDED BY fields are not on any layout (other than the
query form). So you need to put them onto some layout (in other words you need
FMP not the runtime). I have both those and the corresponding MODIFED DATE and
MODIFIED BY on my custom layout screen. We run a proof reading report of all
changes since the last report and volunteers check that report with the paper
submissions given to the data entry person. Since many of the submissions are
handwritten, the handwriting is open to interpretation and it helps to have
someone else guess what the paper says.
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
---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------
|
