Filtering between 2 dates

Discussion created by noushie on Mar 15, 2012
Latest reply on Mar 16, 2012 by ariley

I would like to be able to select records that are between 2 dates. ie all donations between 1/3/12 and 16/3/12. How would one go about filtering records like this?

I have a table of donations, which includes the date, amount etc. each with a unique identifier (ie __kp_DonationID). These are then linked to the contact who made the donation (via _kf_ContactID.)