AnsweredAssumed Answered

Calculation Date Range return a text result

Question asked by KristinaMcNamee on Nov 3, 2010
Latest reply on Nov 3, 2010 by ryan

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.

Outcomes