I just tried your request. It only worked if I included a leading '0' in
the date if the day or month is single digit (03/03/1999..12/12/2000).
Also, make sure to use the full 4 digit year code (2000).
In my search, I was looking for 'Lapsed' under Status. It worked fine and
found the currect records.
Michael W. Smith
MWS Consulting
Vancouver, BC Canada
Mailto:[EMAIL PROTECTED]
-----Original Message-----
From: DADS Info [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 12:25 PM
To: TechRocks Support
Subject: [support] Re: Queries
Using the full year didn't work either.. I have tried restarting the
computer and Ebase, I have tried many different things, but nothing is
working.
Dads and Daughters
www.dadsanddaughters.org
[EMAIL PROTECTED]
218-722-3942
218-722-4058 (fax)
PO Box 3458
Duluth, MN 55803
----- Original Message -----
From: "Gale Sterrett" <[EMAIL PROTECTED]>
To: "TechRocks Support" <[EMAIL PROTECTED]>
Sent: Wednesday, July 11, 2001 2:24 PM
Subject: [support] Re: Queries
> There are times I have had to enter 4/1/2001 using the full year. Try
that.
>
> ----- Original Message -----
> From: DADS Info <[EMAIL PROTECTED]>
> To: TechRocks Support <[EMAIL PROTECTED]>
> Sent: Wednesday, July 11, 2001 12:05 PM
> Subject: [support] Queries
>
>
> > This is important so if you can answer me back right away that would be
> > great. I am trying to set up a query using the Post Date and the
Member
> > Status to create lists of people for different renewal letters we have.
> > however when I enter the post date (ex 3.1.00...4.31.00) for a search
it
> > will not let me do anything it says its entered wrong so then I enter
it
> the
> > way it wants me to (3/1/00...4/31/00) and it still says its not right.
I
> am
> > not sure what I am doing wrong and I need to send these letters out
soon.
> if
> > you could help me I would appreciate it a lot.
> > Thanks
> > Jessica
> > Dads and Daughters
> > www.dadsanddaughters.org
> > [EMAIL PROTECTED]
> > 218-722-3942
> > 218-722-4058 (fax)
> > PO Box 3458
> > Duluth, MN 55803
> > ----- Original Message -----
> > From: "Walt Daniels" <[EMAIL PROTECTED]>
> > To: "TechRocks Support" <[EMAIL PROTECTED]>
> > Sent: Tuesday, July 03, 2001 11:31 AM
> > Subject: [support] RE: Maximum amount of entries
> >
> >
> > > You will most likely run out of disk space before you run out of
number
> of
> > > entries, 2G. There are people with FileMaker files with millions of
> > entries,
> > > some eBase users may have as many as 100,000, perhaps more. There are
> some
> > > processes that you might run in eBase whose time of execution goes up
> > > significantly if you have very large numbers. We have 20,000+ and
> searches
> > > on unindexed fields are a bit tedious. You quickly learn which things
> are
> > > slow and don't do them if not necessary, e.g. the expire date field
is
> > > computed, not indexed but there are fast find fields (which are slow
to
> > > update - but make finding fast if you need to do them multiple
times.)
> > >
> > > All of the different import possibilities work about the same - no
> > > preference.
> > >
> > > > -----Original Message-----
> > > > From: DADS Info [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, July 03, 2001 11:53 AM
> > > > To: TechRocks Support
> > > > Subject: [support] Maximum amount of entries
> > > >
> > > >
> > > > Hello everyone, I was just wondering if anyone knew if Ebase had a
> > maximum
> > > > number of entries that can be entered into ebase and if it does
> > > > what is that
> > > > number.
> > > > Another question is when importing a huge amount of names and
member
> > files
> > > > what is the best way to do this, is it by excel or....
> > > > I hope I have explained this well enough.
> > > > Any feedback would be appreciated.
> > > > Thanks
> > > > Jessica Flipp
> > > > Dads and Daughters
> > > > www.dadsanddaughters.org
> > > > [EMAIL PROTECTED]
> > > > 218-722-3942
> > > > 218-722-4058 (fax)
> > > > PO Box 3458
> > > > Duluth, MN 55803
> > > > ----- Original Message -----
> > > > From: "office" <[EMAIL PROTECTED]>
> > > > To: "TechRocks Support" <[EMAIL PROTECTED]>
> > > > Sent: Tuesday, July 03, 2001 7:58 AM
> > > > Subject: [support] Importing Names
> > > >
> > > >
> > > > > Hope someone can help me with this minor problem...
> > > > > I am trying to import names into ebase and everything is working
> fine
> > > > except
> > > > > the zip code. It is importing as four digits instead of five. I
> have
> > > > > imported before and not had a problem so I'm not sure what I'm
doing
> > > > wrong.
> > > > > And, other than the zip code, the import is working great. I
> > > > am importing
> > > > > from an excel file which shows the correct five numeral zip code.
> Any
> > > > > suggestions? They'd be very much appreciated.
> > > > >
> > > > > Thanks,
> > > > > Pam McChesney
> > > > > Shoreline Arts Alliance
> > > > >
> > > > > - - - - - - - - - - - - - - - - - - - -
> > > > > Shoreline Arts Alliance
> > > > > www.shorelinearts.org
> > > > > Discover the best music, theatre and
> > > > > arts events on the Shoreline:
> > > > > www.shorelinearts.org/calendar.cfm
> > > > >
> > > > >
> > > > > ------------------
> > > > > 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:: [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::
> > [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::
> [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::
[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::
[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:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------