Calculation for no donation in last 3 years
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??