How does Double the Donation handle timestamps on donation records?

This article walks through how 360MatchPro handles 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).