Interpret recurring duration in online-giving exports

Export duration is expressed in years

In the online-giving report view, a limited_months gift's stored month count is divided by 12 and rounded to two decimal places for recur_length. Therefore recur_period = limited months with recur_length = 0.75 represents nine months, not three quarters of an installment.

For yearly or monthly schedules the exported recur_length is the stored duration in years. The report's max_installments field is separate: yearly uses the year count, monthly multiplies the year count by 12, and limited months uses the stored month count. Use that installment-count field when you need the count rather than reverse-calculating from a rounded year value.

Availability and limitations and caveats

Indefinite schedules have special output rather than a finite duration. Confirm the exact export column and report type before applying this formula; a raw database or API field can use different units. A configured installment count is not evidence that all installments have been paid.