3 Replies Latest reply on Mar 16, 2012 6:29 AM by ariley

    Filtering between 2 dates

    noushie

      I would like to be able to select records that are between 2 dates. ie all donations between 1/3/12 and 16/3/12. How would one go about filtering records like this?

      I have a table of donations, which includes the date, amount etc. each with a unique identifier (ie __kp_DonationID). These are then linked to the contact who made the donation (via _kf_ContactID.)

       

      Noushie

        • 1. Re: Filtering between 2 dates
          ariley

          You need to filter the records from a table you use for viewing records only. You can call that table interface or goal or anything else you'd like. Then create 2 date fields that table (global is fine). You use those fields for filtering. Connect your donation table to this new table:

           

          date1 > = donation date

          date2 < = donation date

           

          Create a layout from your "interface" table. Put your donation records on it from a portal from the new TO you just connected to the interface table. Put the two new date filters out and you can start filtering.

           

          Have fun!

           

          agnes b. riley . filemaker and web development

          www.zerobluetech.com

          T 201-299-6223 (NJ) . 212-842-8830 (NY) . 917-660-7221 (C)

          FileMaker Certified in 10 and 11

          • 2. Re: Filtering between 2 dates
            jason.delooze

            Small clarification.  In Agnes' reply, she used the assumption that date2 <= date1; that is, her join will show all records from date2 to date1 (instead of from date1 to date2).  Just thought I would clarify that in case you set it up and it showed no records in the portal.

            • 3. Re: Filtering between 2 dates
              ariley

              Well, yes, I could've been more verbose, but it's too early in the morning.

               

              agnes b. riley . filemaker and web development

              FileMaker Business Alliance . FileMaker Technical Network

              www.zerobluetech.com (http://www.zerobluetech.com)

               

               

              T 201-299-6223 (NJ) .

              212-842-8830 (NY)

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

              .

              917-660-7221 (C)

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

               

              FileMaker Certified in 10 and 11

              people + products + events + todos + invoices + documents = productivity