PeterCortiel

select years

Discussion created by PeterCortiel on Apr 22, 2017
Latest reply on Apr 22, 2017 by Menno

I have a donations -> donors pair of tables

I need to find the donors who donated during the last 3 years but not yet this year.

I have a date_donated field in donations

 

This gives me what I need

 

 

ExecuteSQL (

"select   b.kp_donors_id,

b.fullname,

a.deposit_date_year

from donations a

Join donors b on a.kf_donors_id = b.kp_donors_id

Where year (a.date_deposited) in (2016, 2015, 2014) and not year (a.date_deposited) =2017 ";

"";

""

)

 

But I don't know what to do with it

Once I know how I can use to filter the donors i'll replace the hard coded years with calculated values

Can anyone help?

 

Peter

Outcomes