I had to set up a regular report to handle importing dates with 2-digit
years from another system. They arrive as a delimited text file. FileMaker
(we use v4) doesn't handle date conversions well on import and our data came
in as 1901, etc. What I did was to create a new Text field (one of the
existing user fields would also work fine). I import the dates into the text
field, then alter it using Substitute() or Replace() to force m/d/01 to
m/d/2001, for example. Then I move it to the date field using Replace with
Calculated Result with the TextToDate(Text Field) function.
HTH,
Gary
> Subject: RE: Date display
> From: "Walt Daniels" <[EMAIL PROTECTED]>
> Date: Tue, 7 Aug 2001 12:33:11 -0400
> X-Message-Number: 9
>
>
> > 1. On the home screen, the display for "Donor Date" should be showing
> the
> > date of the last payment received from the donor. What is actually
> > showing is the last payment received prior to 01/01/2000. It apprears
> > that the year 2000 dates are being interpreted as 1900 and the 2001 are
> > being read as 1901, etc. I am using four digit dates unless I've failed
> > to turn it on properly.
> >
>
> There is nothing to turn on about 4 digit year processing. You must
> specify
> all 4 digits everyplace (except on hand data entry of year where 20xx is
> assumed). Persumably you only had 2 digit years on your import records.
>
------------------
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
---------------------------------------------------------------------
