>You're correct, I did use just 2 digit years on my import data. Is there a
>global action that I could do that would let me change all my import data
>now in ebase (I only have imported data there at the moment)?
Donor Date is calculated and looked up from the Post Date field in
the payments file. That's the field you want to work on here.
First, back up your file set so you can restore it if you have
unexpected results.
Find all the payment records you want to work on (all of them with
post dates earlier than 2000, or maybe 1950, to be sure you get only
the ones you want.).
Run the FileMaker Replace command and replace the Post Date with a
calculated value
Date(Month(Post Date), Day(Post Date), Year(Post Date)+100)
>As for the view payments issue, I identified all my special events
>contributions as "Payment For" Event/Purchase and imported them as such. In
>addition, I created a source code for each event on my legacy data using the
>ebase scheme for such codes. What is happening is that the purchase column
>is not picking up these "Payment For" events but the data is in the system.
>Guess I need to figure out how to spec up the "view payments" report so that
>the "purchase" column reads the data that is there.
The value in the Payment For field needs to be Event\Purchase (note
backslash), not Event/Purchase. You can use the Replace command again
here - find all the payment records you have coded as Event/Purchase
and replace with the correct value.
--
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
------------------
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
---------------------------------------------------------------------
