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

    • 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) Campaign name Donation identifier number  ...
    • 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 ...
    • Does Double the Donation Integrate with Salesforce?

      Step-by-Step: Activating the Integration between 360MatchPro and Salesforce 360MatchPro is the industry-leading matching gifts automation solution for nonprofits and educational institutions to identify more matching gift revenue opportunities and ...
    • Top Records

      Within the Statistics tab in 360MatchPro, you'll find the Top Records identified in the following sections: Forms Available By Status  Forms Available Within the Forms Available tab, you are able to see donation records that have an online form ...