Calculation Date Range return a text result
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.
( 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.