Donation Type and Transaction Date

Dennis Orita

Hello, all.

 

I'm attempting to replicate some canned donation reports and it seems that many of the donation reports are based on transaction date. However, transaction date is not an available field in the Donation type or any other type from what I can see. When I attempt to use some other date, creation date, payment date, or modify date, none of those dates match what the value is for transaction date for a particular donation/transactions. It's problematic when dealing with transactions occuring around midnight.

 

Does transaction date exist somewhere else, is it completely unavailable, or is there some other workaround for this?

Kent Gilliam

Are you trying to use an API to pull this info or just a regular report? I think you may have posted in the wrong forum.

Dennis Orita

Kent Gilliam:

Are you trying to use an API to pull this info or just a regular report? I think you may have posted in the wrong forum.

Hi, Kent.

 

I'm using the API; specifically, I'm using the query method to get donations within a certain timeframe. I'm only using the canned donation reports in Convio to compare values with the data I'm retreiving through the API. I understand that with the report writer and canned reports, this field called transactiondate is used very frequently but it isn't available in the API.

 

In an attempt to recreate the transactiondate field I took paymentdate and adjusted the value by -6 hours which almost seems to work, just not 100%.

 

Thanks a lot.

Steve Mook

Dennis Orita:

Hi, Kent.

 

I'm using the API; specifically, I'm using the query method to get donations within a certain timeframe. I'm only using the canned donation reports in Convio to compare values with the data I'm retreiving through the API. I understand that with the report writer and canned reports, this field called transactiondate is used very frequently but it isn't available in the API.

 

In an attempt to recreate the transactiondate field I took paymentdate and adjusted the value by -6 hours which almost seems to work, just not 100%.

 

Thanks a lot.

I am fairly sure that Transaction Date in the reports and Donation.Payment.PaymentDate in the web services API reference the same data field. Two things to look at are the timezone offset, and whether or not you're actually looking for the Settlement Date.

Dennis Orita

Steve Mook:

I am fairly sure that Transaction Date in the reports and Donation.Payment.PaymentDate in the web services API reference the same data field. Two things to look at are the timezone offset, and whether or not you're actually looking for the Settlement Date.

Thanks, I'm pretty sure I'm battle a timezone issue here so I'll dig into it some more. It helps to have confirmation that Transaction Date and Payment Date should be the same.