In a solution I wrote for schools in Illinois, I had a field for the start date of the school year and a field for the end date of the school year. I then compared the current date and and had a field set as Y/N as to a given date (usually the current date) being in the year. You could use July 1 to June 30 as month day and have the year be the begin and end years for each school year. Then have a calculation that generates a number (perhaps "0" for the current year and plus / minus digits for other years. Then make your self join for "0". I hope this helps. Rick
> 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 >
