Thanks to everyone who chimed in on this one. I think Jim's version I can work with best. And by the by (or is it bye the bye??) , our fiscal year does start on July 1 (7). Sweet.
Deb On 2/7/07 6:29 PM, "Jim Main" <[EMAIL PROTECTED]> wrote: > 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] > -------------------------------------------
