A classic workaround to save brain cells is to create a table of
dates - record for every day and then assign an identifier in another
field. 7/1/2006 to 6/30/2007 could be flagged as 2006-2007,
7/1/2007 to 6/30/2008 as 2007-2008. Or they could be any text value
- The table of dates is a lookup source for the dates in the table
you need to view. Then your portal can use simpler keys eg. 2006 to
2006, 2007 to 2007 etc.
Or you could make a calc field that concludes that a month <=6 is
last year while month > 6 is also last year or maybe both this year.
Anyway you join to the calc'd value.
On Feb 7, 2007, at 8:10 AM, Deborah Tinsley wrote:
Yesterday I learned how to construct a portal to show only records
from the
current year. I created a calc field - Date (1;1;year
(GetCurrentYear))) and
then created a new table occurrence called "Current Year". Creating a
relationship non-equious join (equal to or greater than) between
the Orders
file to the Patron file (with the calc field in the patron file),
the portal
shows all the orders for this year.
Very cool. [Thanks to the Love, Lane and Bowers book, "Using
FileMaker 8"].
But I work at a school and our academic year goes from July to
June, which
covers two years. I'm not sure how to even start to construct a
portal that
will show orders from 7/1/2006 to 6/30/2007. I just can't figure
out where
to start. Can someone get me started?
Deb
Deborah Tinsley
Assoc. Librarian of Visual Resources
Kansas City Art Institute
[EMAIL PROTECTED]
816 802 3395
