AnsweredAssumed Answered

Calculation for no donation in last 3 years

Question asked by mb3210 on Aug 22, 2012
Latest reply on Aug 27, 2012 by mb3210

Title

Calculation for no donation in last 3 years

Post

Hi!

I'm struggling with writing a proper calculation for the field No Donation in Past 3 years (also including no donation ever made.  I want to use this field in a script to get a list of these donors sorted by the date of last donation.  After alot of effort I came up with:

Year ( Date_Last_Donated ) ≤ Year (Get( CurrentDate)) - 3       

I indicated the result to be text.  It does not return the proper result.  Can you help??

Outcomes