Hello again Tessiturians! Trying to output the last contribution date for a list of patrons. The existing output set element, Customer_last_gift_date actually outputs the last transaction date rather than the last gift date. Does anyone have a good way to pull this information out? Thank again!
Carli WebbInformation Systems SpecialistPlayMakers Repertory Companycfwebb@email.unc.edu
We have a custom element for something like this: for the latest contribution date all time, regardless of campaign, the Data Select column in TR_QUERY_ELEMENT includes:
convert(varchar(10),max(date),101)
If you don't want the mm/dd/yyyy date that this produces, you could leave out the "convert(varchar(10)...,101)" code. And in our case we are selecting from a view that include soft credits rather than from t_contribution, hence the "date", but you could substitute cont_dt if you wanted to pull from t_contribution, and use simply
max(cont_dt)
Awesome! Worked like a charm. Thanks Chris!
Carli