[support] RE: Add Date

Art Horne Mon, 08 Apr 2002 06:38:09 -0700

Hello Friends,

Is there a report already in ebase 1.02 for year end? I want to mail all our donors the information as to what they have given in a year.

Art Horne, CFRE

124 South Jackson, Suite 318

Magnolia, AR 71753

Phone: 870.235.3333

Fax: 870.234.1925

-----Original Message-----
From: Walter Daniels [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:13 AM
To: TechRocks Support
Subject: [support] RE: Add Date

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.

-----Original Message-----
From: Kathleen Ackley [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:24 AM
To: TechRocks Support
Subject: [support] RE: Add Date

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

From: Walter Daniels

To: TechRocks Support

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.

-----Original Message-----
From: Kathleen Ackley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 4:59 PM
To: TechRocks Support
Subject: [support] Add Date

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

[support] RE: Add Date

Reply via email to