It was recently discovered that the import data flow for opportunities was incorrectly converting the “Close Date” field from date to datetime.
Background: in rampmetrics, dates are always stored as datetime, meaning that there is always a time associated with a date stamp. In Salesforce, “Close Date” is always stored as a date field with no time associated. When a date field is converted to a datetime field, the conversion assumes the time to be 12am UTC on the date in question. That converted datetime field then get translated to the rampmetrics local time zone, which is UTC -8 hours. Therefore, a Close Date in salesforce of, for example, January 1, 2023 would get converted in rampmetrics to December 31, 2022, at 4pm.
Resolution: rampmetrics now adds enough hours to these converted date stamps so that they show up on the correct day.