Basically you need to figure out the first date for the current
academic year:
Let (FirstMonth = 7,
Date ( FirstMonth ; 1 ; Year ( Today ) - Case (Month (Today) <
FirstMonth, 1) )
)
You can replace the 7 with any month that is your first academic
month. If it's January, you'll simply never have the Case statement
validate as true, and get your simplified version below.
On Feb 7, 2007, at 7: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
Jim Main
-------------------------------------------
619-948-5293
[EMAIL PROTECTED]
-------------------------------------------
