1) Make a copy of the paymnts_.10x file.
2) Find all payments where post date is in the range 1/1/1900...12/31/1901
3) Replace the post date in the found set with the following calc:
Date( Month(Post Date), Day(Post Date), Year(Post Date) + 100)
4) If this doesn't work, you can revert to the copy you made in step 1.
>By mistake I imported 355 records from my Y2K-afflicted legacy database
>with 1901 post dates for 2001. How can I use FMP Replace to change 1901 to
>2001 but leave the mo. and day the same? I think it must be using a
>calculated result but I don't know how to write the calculation. Thanks.
---------------------------------------------------------------------
Jack Noll - ebase consultant and wildlife advocate
Check out a *great* program at www.beardogs.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
---------------------------------------------------------------------
