Deborah:
I found a calc at Brian Dunning's site
http://www.briandunning.com/filemaker-custom-functions/list.php that
might help in determining the academic year.
Let(TheFY = Year( Date_Entered ) + ( Month( Date_Entered ) >=
FY_StartMth );TheFY-1)
The FY_StartMth = 6
Check the site for better instructions.
Peter
On Feb 7, 2007, at 10: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
