AnsweredAssumed Answered

Date Calculation field

Question asked by symbister on Jan 7, 2013
Latest reply on Jan 8, 2013 by symbister


Date Calculation field


     Ok, this has to be so easy but it's driving me crazy...

     I have a related table of donations made by constituents listing amount, date etc.

     What I'm wanting is a very simple calc field to give me a "yes", if these conditions are met

     Date is later than 1 January 2012 AND

     Amount is greater than $500

     I've tried a number of permutations using nested If's or Case's but nothing's doing it for me...

     So, I went back a step and created two calc fields, one that does return True if the amount is greater than $500, and a second one that is supposed to return True if the date is greater than 1/1/12 - but this doesn't work:

     If (donation_date > "01/01/2012" ; "Yes" ; "No") [donation_date is type date, calc is unstored]

     any help will be appreciated, thanks