>We successfully imported our payment records but ebase/Filemaker >replaced 2000 with 1900 even though it was in a four-digit format in our >original database (Panorama).
Is the date correctly formatted with 4 digits in the export file? Or did Panorama export a short date format? >Is there any way to fix this in >ebase/Filemaker now or how can we re-export to correct this problem? > Assuming you can isolate the incorrect records (by searching for all payments with a post date in 1900, for example)... Find the set of records to change Put a cursor in the post date (this is the field with the incorrect date, right?) Select the FileMaker Replace Command from the Scripts Menu Click the button to do a calculated replace Replace with this formula... Date (Month(Post Date), Day(Post Date), 2000) -- -- 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 ---------------------------------------------------------------------
