imported from_date, to_date slightly off

We're checking out OS Membership, hoping to switch from OSE. The import subscribers from cvs seems to working but the from/to dates end up bumped up a day. I'm not sure what to check. We're GMT-7, here's a data sample. Thoughts?

"org_from_date","imported_from_date","org_to_date","imported_to_date"
"2011-07-25 16:01:04","2011-07-26 05:59:59","2023-07-27 00:00:00","2023-07-28 05:59:59"
"2011-08-18 20:42:24","2011-08-19 05:59:59","2013-04-01 11:21:29","2013-04-02 05:59:59"
"2012-05-01 16:16:00","2012-05-02 05:59:59","2018-08-06 00:00:00","2018-08-07 05:59:59"
"2010-10-01 00:00:00","2010-10-02 05:59:59","2011-09-30 00:00:00","2011-10-01 05:59:59"
"2012-08-31 17:25:00","2012-09-01 05:59:59","2050-10-27 15:19:00","2050-10-28 06:59:59"
"2007-12-01 00:00:00","2007-12-02 06:59:59","2008-11-30 00:00:00","2008-12-01 06:59:59"

Hello David

The system expect data given from your site timezone. Could you please go to System -> Global Configuration, check and make sure the timezone is correct set to your timezone?

Tuan

Hi Tuan,

I checked my System->Global Configuration timezone, it's correct. I changed my export to drop the time portion of the date and it worked fine. Now each date gets the time of 23:59, the end of the day. Moving forward now.

Great David. As long as it works, it will be fine. I will try to look at the import code again to see why the time is changed during the import but since you have a solution, I won't make it as high priority for now

Thanks again for the update

Tuan