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.)