[support] Re: Q: Regarding Replacement and modification to payments data

[Walter Beardwood]

Fixed with: If (Duration="03/97",Date(03,01,1996), Employer) ----- Original Message ----- From: Walter Beardwood To: TechRocks Support Sent: Monday, June 04, 2001 2:48 PM Subject: [support] Re: Q: Regarding Replacement and modification to payments data I have a problem replacing [start date] information in the payments table. I am modifying our old dataset to cooperate with Ebase.. Fun. Here is what happens:   *Entered in Specify Replace* If (Duration="03/97","3/1/1997", Employer)   -If the [duration] field matches the above, then the [start date] is replaced, else it will be emptied with a null field from [Employer].   *Results* Specific correct fields in [start date] are replaced with 3/21/0855 instead of 3/1/1997!!!!! I cannot explain this strange error.   Anyone want to take a hack at it?   Walter Beardwood Database Administrator The Exploration Place         ------------------ 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:: archive@jab.org To unsubscribe send a blank email to [EMAIL PROTECTED] --------------------------------------------------------------------- ebase - Relationship Management for Nonprofits, http://www.ebase.org ---------------------------------------------------------------------