2 Replies Latest reply on Nov 3, 2010 9:40 AM by ryan

    Calculation Date Range return a text result

    KristinaMcNamee

      Title

      Calculation Date Range return a text result

      Post

      Hello

      I am creating a simple database for a non profit to track contacts, donors, and ticket purchases using filemaker pro 9 on a mac.

      I am trying to auto enter information into a field based on a date range through a portal. I would like to automatically generate the tax year once a donation date has been entered. Here is the calculation I am using.

      the donation date field is a date field.

      Case
      ( Donation Date   ≤  Date (12; 31; 2010) and Donation Date  ≥  Date (1; 1; 2010); Tax Year  =  " 2010 " ;  
      Donation Date   ≤   Date (12; 31; 2009) and  Donation Date  ≥  Date (1; 1; 2009) ; Tax Year  =  " 2009 "  )

      please help me.