How does Double the Donation handle timestamps on donation records?

How does Double the Donation handle timestamps on donation records?

When 360MatchPro processes a donation record, it expects a timestamp that contains the date, time, and time zone (e.g. UTC offset from Greenwich Mean Time) using the standard ISO 8501 format of YYYY-MM-DDThh:mm:ss+hh:00.

How does 360MatchPro process timestamps when a time and time zone are missing?

When 360MatchPro processes a date like “2020-06-30”, there is a lot of ambiguity in the absence of a time and time zone.  By default, 360MatchPro appends T00:00:00-00:00 to the timestamp.  This is functionally equivalent to saying the donation was made in Greenwich, England at midnight on June 30.

Why is this a problem, and why may your donations appear one day behind?

By default, 360MatchPro displays timestamps using the Eastern time zone in the platform and in emails. But if an ambiguous date is processed using the GMT time zone and displayed in the Eastern time zone, the donation may appear one day behind since the Eastern time zone is five hours behind GMT.  

How do I get around this problem?

In 360MatchPro, navigate to Settings->Advanced Settings. Set the second input box in the card so that it matches the first one as illustrated below.

You do not have to set the time zones to Eastern Time as long as the display time zone (first input box) matches the processing time zone (second input box).

    • Related Articles

    • How are donation records identified in 360MatchPro?

      For any individual donation record, we determine where a donor works and if that company has a matching gift program in a number of ways. The four primary ways are listed below: 1. Matching Gift Search Field: One way we can identify where a donor ...
    • Sorting and Filtering Donation Records

      Within your 360MatchPro account portal, you have the ability to sort and filter donation records to narrow down the exact data that you are looking for. Filtering Donation Records You have the ability to filter donation records based on the ...
    • Understanding Individual records

      Each donation record includes the following information:  Donation date First and last name of the donor Donation amount Donor’s email address Phone number (if applicable) Company name (if applicable) Donor Status Campaign name Donation identifier ...
    • Getting Started: Advanced Settings

      Advanced Settings In an effort to reduce the number of donors in the Unknown Employer status and save the donor's company name for the past 6 months, this Advanced Settings option is available. By checking the box under Advanced Settings, when a ...
    • Blocklist: How Records are Added

      Adding Donation Records to Blocklist Donation records can be added to the blocklist in the following ways: If you have direct CRM integration with 360MatchPro and have donation records tagged "Do not email" those donation records will be added to the ...